Courses / Commodity Trading Operations & ERP
Accounting integration — from operational document to general ledger
How receipts, bills and shipments become journals, why finance must sign off the set-up before anything posts, and what month-end needs.
Lesson 1 · free to read
From operational document to journal
A trading system creates operational documents: receipts, bills, shipments, invoices. The ERP turns each into general ledger entries using posting classes: settings on items, vendors and customers that say which accounts each kind of document hits. Configuration decides whether the numbers are right.
The standard perpetual-inventory entries (as in Acumatica):
| Event | Debit | Credit |
|---|---|---|
| Goods received | Inventory | Purchase accrual (goods received not invoiced, GRNI) |
| Supplier bill released | Purchase accrual | Accounts payable |
| Goods issued (shipped or invoiced, per set-up) | Cost of goods sold | Inventory |
| Customer invoice released | Accounts receivable | Sales |
The purchase accrual is a clearing account: every receipt should be matched by a bill, so the account nets to zero over time. A balance left in it is a list of goods received and not yet billed, or billed and not received.
Three questions an outsourced accountant asked about a small trading company's books. They make a good test of whether you understand the table above.
- "Why is stock posting to an accrual account?" Because that is the GRNI entry: at receipt the supplier has not billed yet, so the credit goes to the accrual, not to payables.
- "Why is there no cost of goods sold entry on the sale?" Cost of sales posts when inventory is issued. Check whether the shipment was released, whether the set-up recognises cost at invoice instead, and how the item is valued.
- "Why do credit balances sometimes show positive and sometimes negative on the trial balance?" A report sign convention, not an accounting error: a setting chose to show debits positive and credits negative.
A fourth trap from the same set-up: the option to update the GL had been left off during testing. Nothing posted until it was switched on. Check that before investigating "missing" entries.
Posting is continuous, not a month-end job. The table above is the point of the integration: each operational event posts the moment it happens, so accruals, actuals and valuations are current every day. Month-end closes, reconciles and reports on entries that are already there. A set-up that batches everything for the last day of the month has rebuilt the problem the system was bought to remove.
The rest of this module
- Set it up right, and get finance to sign it offChart of accounts, posting classes, tax, currency and periods must be approved before automatic posting starts.
- Month-end, multiple entities, and connecting to another ERPWhat a trading company's close has to cover, and the traps in pulling data from a second ERP.
Carry on with the course
The other lessons and the quiz are in the course itself, where your progress is saved and counts towards the certificate: Commodity Trading Operations & ERP.
Next module: Bank reconciliation — when the statement, not the ledger, is wrong