+1 480 485 7373
Microsoft Teams
What the general ledger does, and what feeds it
In Business Central almost nobody types straight into the general ledger. Sales invoices, purchase invoices, payments, inventory adjustments and depreciation all post through subledgers, and posting groups decide which G/L accounts each one hits. A customer posting group points receivables at the right control account; a general business and product posting group combination decides the revenue, cost and discount accounts.
That design is why the ledger and the subledgers stay in agreement without a monthly tie-out spreadsheet. It is also why a poor posting group matrix causes so much pain: every document inherits the mistake, and fixing it later means reversing entries rather than editing a setting.
General journals still matter for accruals, reclassifications and the odd manual entry, and recurring journals handle rent, standing allocations and similar entries that repeat each period.
Setup decisions that shape every report you will run
Chart of accounts
Keep it lean. Departments, locations and product lines belong in dimensions, not in hundreds of near-duplicate G/L accounts.
Dimensions
Two global dimensions are stored on every ledger entry for fast filtering; up to eight shortcut dimensions can be shown on lines, and more exist behind the dimension set.
Posting groups
Customer, vendor, inventory, general business and general product groups together route each transaction. Fewer, clearer groups are easier to audit.
Allowed posting dates
General Ledger Setup and User Setup restrict which dates people can post to, which is how a closed month stays closed.
Financial reports
Formerly called account schedules, these row and column definitions produce the P&L, balance sheet and management packs directly from the ledger.
Sales tax and 1099
US tax areas, jurisdictions and groups calculate sales tax on documents, and vendor 1099 codes feed year-end reporting.
Month-end work the standard module already handles
- ✓Bank account reconciliation with automatic matching of imported statement lines to ledger entries.
- ✓The payment reconciliation journal, which applies incoming customer payments from a bank file in one pass.
- ✓Deferral templates that spread prepaid expenses or annual subscriptions across the right periods at posting.
- ✓Allocation accounts that split a single cost such as rent or insurance across departments by fixed or variable shares.
- ✓Fixed asset depreciation books, with straight-line and declining-balance methods and a depreciation calculation batch.
- ✓Exchange rate adjustment for foreign currency balances in receivables, payables and bank accounts.
- ✓Year-end closing of income statement accounts into retained earnings, while prior periods remain reportable.
- ✓Positive pay export files for US banks that support check fraud screening.
Mistakes that make the close slower, not faster
The most common one is copying the old chart of accounts line for line. If QuickBooks or an older system carried a separate revenue account for every branch, those accounts get recreated, dimensions are left empty, and reporting ends up needing the same spreadsheets as before.
The second is leaving posting date ranges open. Without them, a late invoice dated into a closed month quietly changes a reported number. The third is skipping the bank reconciliation setup: if statement import is not configured, staff match lines by hand and the automation never gets used.
Finally, teams often build every management report in Excel on day one. Financial reports inside Business Central are worth learning first, because they refresh from posted data and carry dimension filters with no export step.
How we configure finance for your company
- 1
Map how you report today
We collect the reports your owners, lenders and auditors actually read, then work backwards to the accounts and dimensions that must exist to produce them.
- 2
Design the chart and dimensions
A proposed chart of accounts, dimension list and posting group matrix goes to your controller in writing for approval before anything is configured.
- 3
Load balances and open items
Opening trial balance, open customer and vendor items and fixed asset values are imported through configuration packages and reconciled to your old system.
- 4
Rehearse a month-end
Your team runs a full close in a sandbox: bank reconciliation, deferrals, depreciation and financial reports, so problems surface before go-live.
- 5
Lock and hand over
Posting date controls, approval workflows and user permissions are set, and your staff get a written close checklist tied to Business Central pages.
Finance questions controllers ask us
Is Business Central enough for a company with audited financial statements?
For most small and mid-sized US companies, yes. It keeps a complete, unchangeable audit trail of posted entries, supports multiple currencies and companies, and produces a P&L and balance sheet from financial reports. Where firms outgrow it is usually very large transaction volumes or complex revenue recognition rules, and we will say so plainly if that applies to you.
Can we keep our current chart of accounts?
You can, but we usually recommend trimming it. Business Central dimensions do the job that extra accounts did in older systems, and a shorter chart makes reports easier to maintain. We map every old account to its new home so history still lines up.
How are month-end accruals handled?
Accruals go through general journals, often with the reversing option so the entry flips automatically on the first day of the next period. Recurring accruals can sit in a recurring journal. Deferral templates cover the opposite case, where a cost or revenue must be spread over several months.
Does it handle revenue recognition for subscriptions?
Deferral templates handle straightforward cases where revenue is spread evenly or by days over a set period. Contract-based recognition with changing terms, usage billing or multiple performance obligations usually needs an AppSource app or an extension. We look at your contracts before suggesting either.
Can we still use Excel for reporting?
Yes. Most list pages open in Excel, financial reports export directly, and the Excel add-in lets you edit journal lines in a spreadsheet and publish them back. We just try to make sure Excel becomes a convenience rather than the place the real numbers live.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.