+1 480 485 7373
Microsoft Teams
How the general ledger works in Business Central finance
In Business Central almost nobody types straight into the general ledger. Sales and purchase invoices, payments, inventory adjustments and depreciation all post through subledgers. Posting groups then decide which G/L accounts each one hits. A customer posting group points receivables at the right control account. Then a general business and product posting group pair picks 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 hurts so much. Every document inherits the mistake, and a later fix means reversing entries, not editing a setting.
General journals still matter for accruals, reclassifications and the odd manual entry. Recurring journals also handle rent, standing allocations and other entries that repeat each period.
Business Central finance setup decisions that shape every report
Chart of accounts
Keep it lean. Departments, locations and product lines belong in dimensions, not in hundreds of near-duplicate G/L accounts.
Dimensions
Every ledger entry stores two global dimensions for fast filtering. You can show up to eight shortcut dimensions on lines, and more sit 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 limit the dates people can post to. That is how a closed month stays closed.
Financial reports
These row and column definitions were once account schedules. Now they 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.
Number series
Posted invoices and credit memos draw from their own number series. Keep gaps switched off, so auditors get a continuous sequence.
Accounting periods
The fiscal calendar drives year-to-date figures, closing and report columns. So if your year does not start in January, set it before the first posting.
Month-end work Business Central finance and accounting 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.
- ✓Reversal of posted journal entries from the G/L register, which posts an exact opposite entry instead of editing the original.
Business Central accounting mistakes that slow the close
The most common one is copying the old chart of accounts line for line. Say QuickBooks or an older system carried a separate revenue account for every branch. Copy those accounts across and the dimensions sit empty, so reporting needs 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. Without statement import, staff match lines by hand and nobody uses the automation.
Finally, teams often build every management report in Excel on day one. Learn the financial reports inside Business Central first. They refresh from posted data and carry dimension filters with no export step.
How we configure Business Central finance and accounting for your company
- 1
Map how you report today
We collect the reports your owners, lenders and auditors actually read. Then we work back to the accounts and dimensions those reports need.
- 2
Design the chart and dimensions
Your controller gets a proposed chart of accounts, dimension list and posting group matrix in writing. We configure nothing until they approve it.
- 3
Load balances and open items
We import the opening trial balance, open customer and vendor items and fixed asset values through configuration packages. Then we reconcile each one to your old system.
- 4
Rehearse a Business Central accounting close
Your team runs a full close in a sandbox, with bank reconciliation, deferrals, depreciation and financial reports. That way problems surface before go-live.
- 5
Lock and hand over
We set posting date controls, approval workflows and user permissions. Your staff also get a written close checklist tied to Business Central pages.
Business Central 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. It supports multiple currencies and companies and produces a P&L and balance sheet from financial reports. Firms usually outgrow it through very large transaction volumes or complex revenue recognition rules. If that applies to you, we will say so plainly.
Can we keep our current chart of accounts?
You can, but we usually recommend trimming it. In Business Central finance and accounting, dimensions do the job that extra accounts did in older systems. A shorter chart also 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. The entry then flips on its own on the first day of the next period. Recurring accruals can sit in a recurring journal. Deferral templates cover the opposite case, where you spread a cost or revenue over several months.
Does it handle revenue recognition for subscriptions?
Deferral templates handle simple cases that spread revenue 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, and financial reports export directly. The Excel add-in also 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.