Journal Entry

The Journal Entry Writeback template creates balanced general ledger journal entries in Acumatica directly from a workbook. Use it for month end adjustments, accruals, reclassifications, intercompany entries, and other manual GL transactions with multiple debit and credit lines. It uses the NECWRITEBACK formula, generated with the Writeback Wizard, to send changes from your workbook back to Acumatica.

Typical workflow

1. Complete the journal entry header.
2. Enter the debit and credit lines in the transaction grid.
3. Review the Validation column and correct any line level errors.
4. Confirm in Batch Check that total debits equal total credits and the status is OK – Balanced.
5. Select Push to Acumatica to create the journal entry.
6. After a successful writeback, use the populated batch reference to open the entry in Acumatica.
7. Select Release to release the entry in Acumatica, if needed.
8. Select Reset before preparing another journal entry.

Entry header

Contains information shared by every transaction line in the journal entry.

Field	What to select
Financial Period	Financial period in which the journal entry will be recorded.
Transaction Date	Date assigned to the journal entry.
Description	Brief description of the purpose of the journal entry.
Batch	Batch number returned by Acumatica after a successful writeback. The populated value links to the created entry.
Posted	Indicates whether the resulting batch has been posted in Acumatica.
Ledger	Ledger to which the journal entry will be written.
Branch	Default branch for the journal entry. Individual lines may use a different branch.
Currency	Currency used for the journal entry.

Writeback actions

Action	What it does
Push to Acumatica	Validates the completed template and creates the journal entry in Acumatica. A confirmation message indicates whether the writeback succeeded.
Release	Releases the journal entry in Acumatica after it has been created. Available only after a successful writeback.
Reset	Clears the current journal entry so the template can be used for another entry. Use this only after the current entry has been successfully written back or is no longer needed.

Transaction grid

Contains the individual debit and credit lines that make up the journal entry. For each, you can enter either a debit or a credit on each line, not both.

Column	What it shows
Branch *	Branch assigned to the transaction line.
Account *	General ledger account to debit or credit.
Subaccount *	Subaccount associated with the selected account.
Project	Project associated with the transaction, when applicable.
Task	Project task associated with the transaction, when applicable.
Ref. Number	Optional reference used to identify or trace the transaction.
Quantity	Optional quantity associated with the journal line.
Debit	Debit amount for the transaction line. Leave blank when entering a credit.
Credit	Credit amount for the transaction line. Leave blank when entering a debit.
Non Billable	Indicates that a project related transaction should not be billed.
Line No	Automatically calculated line number. Do not edit this field.
Validation	Displays missing field errors, invalid combinations, or confirmation that the line is ready.

important

Fields marked with an asterisk (*) are required on each populated line.

Review and release

Before writing back the journal entry:

• Confirm that all required (*) fields are complete on every populated line.
• Resolve any errors shown in the Validation column.
• Check Batch Check to confirm Total Debit equals Total Credit and the difference is zero.
• Confirm the Status shows the entry is balanced and ready for writeback.

The entry can be written back only when all required fields are complete, no line level errors remain, and the debit and credit totals are equal. Writing the entry back to Acumatica and releasing it are separate actions. Release the entry from Acumatica once it's ready.