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.

Module 6 of 123 lessonsAbout 50 minQuiz: 6 questions
Account

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):

EventDebitCredit
Goods receivedInventoryPurchase accrual (goods received not invoiced, GRNI)
Supplier bill releasedPurchase accrualAccounts payable
Goods issued (shipped or invoiced, per set-up)Cost of goods soldInventory
Customer invoice releasedAccounts receivableSales

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.

  1. "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.
  2. "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.
  3. "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

  1. Set it up right, and get finance to sign it off
    Chart of accounts, posting classes, tax, currency and periods must be approved before automatic posting starts.
  2. Month-end, multiple entities, and connecting to another ERP
    What 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