Which G/L account will Macola® use?¶
Adapted from the Leahy Consulting white paper series "How do I know what G/L accounts will be used…", written for Macola® Progression, ES and 10 customers between 2004 and 2020.
Almost every question that reaches our support desk about a surprising general ledger balance comes down to the same thing: a transaction picked up an account nobody expected. Macola® never guesses. Each module follows a fixed order — look in the specific file first, fall back to the module's setup screen if nothing matches — and once you know that order you can predict every posting.
The rule behind all of it¶
Macola® looks for the most specific record it can find, then falls back:
| The posting | Macola® looks first in | If there is no match, it uses |
|---|---|---|
| Inventory, receiving accrual, variances | Material Cost Type/Location Account — keyed by the item's material cost type and the transaction's location | The default accounts in I/M Setup |
| Sales and cost of sales | Product Category/Location Account — keyed by the item's product category and the shipping location | The default sales account in A/R Setup, and the default cost-of-sales account in O/E Setup |
| Accounts receivable | The Customer Type record for the customer | The default account in A/R Setup |
| Accounts payable and cash | The Vendor Type record for the vendor | The default accounts in A/P Setup |
| Shop floor absorption and variances | The Work Center Account Group for the department and work center | Nothing — Shop Floor Control needs these accounts set |
Point the fallbacks at an account you will notice
Set the default accounts in I/M Setup, O/E Setup and A/R Setup
to an obviously wrong account — a 99999 suspense account is the usual
choice. Anything landing there is a gap in your Material Cost
Type/Location or Product Category/Location file, and you find out in the
month it happens rather than at year end.
The guides¶
Where the accounts are held¶
- The set-up screens that hold G/L accounts — Every Macola® ES and 10 screen that carries account numbers, what each account is for, and the full table of transactions that post to it
- Material Cost Type and Material Cost Type/Location accounts — How to set the codes up for Production Order Processing, account by account
- Entering a G/L account number — Adding an account to the Macola® ES chart of accounts, field by field, including what each subadministration code does
What posts where¶
- Manual inventory transactions — Transfers, miscellaneous receipts and issues, cost and quantity adjustments
- Posting customer invoices — The four accounts Order Entry uses, and how to check them before you post
- P/O receiving, A/P vouchering and POP production reporting — The debits and credits at each of the six stages, from purchase order to finished item
- Standard costing and POP value-added costs — The same journey when standard costing is in use, including where the purchase price variance lands
Getting data in¶
- Importing G/L transactions — The Progression ASCII file layout and the Macola® ES CSV and XML import, with the field definitions for both
Support & contact¶
Our team is glad to help with anything from a quick question to a full implementation.
- PULSE software support — (513) 723-8095 · [email protected]
- Sales & product questions — (513) 723-8091 · [email protected]
- Consulting & Macola services — (513) 723-8094 · [email protected]