Skip to main content

Posts

Showing posts with the label Month-End Closing

Business Central: Aged Receivables or Payables Doesn’t Match the G/L? How to Reconcile

The auditor asks for the debtors aging. You print it, and the total doesn't match trade receivables on the trial balance. Now you have to explain the difference. Most of the time it isn't a real difference: the two reports were run differently. When it is real, it's almost always the same thing: someone posted straight to the control account. Here's how to check, find it and stop it happening again. AR and AP work exactly the same way. Quick answer Run the Trial Balance and Aged Accounts Receivable for the same date, with Aging by = Posting Date . The Balance of all your receivables control accounts should equal the aged report's Total (LCY) . Still different? Run Reconcile Customer and Vendor Accounts . The Difference column shows which account is off. Open General Ledger Entries for that account and filter Source Type = blank. Those entries were posted straight to the account, without a customer. Turn off Direct Posting on every receivables and ...

Business Central Year-End Close: Close Year and Close Income Statement Step by Step

Your financial year has ended. Now Business Central needs to zero the P&L accounts and move the year's profit into retained earnings. It takes three actions, and BC does the maths for you. One of them can't be undone , so do them in this order. Quick answer Accounting Periods : make sure next year exists, then choose Close Year . Search Close Income Statement : enter the year-end date, a journal batch and your retained earnings account, then OK . Open that journal batch, check the lines, and Post . Posted something into the old year later? Post it, then run Close Income Statement again. The whole flow at a glance Year-end close in Business Central ▼ 1. Make sure next year exists Accounting Periods → Create Year (if it isn't there yet) ▼ 2. Close Year Accounting Periods → Close Year (can't be undone) ▼ 3. Close Income Statement BC creates the closing lines in a journal ▼ 4. Review and post the journal P&L accounts zer...

Business Central Allocation Account: Auto-Split Costs to Departments Without a Journal

You post the electricity bill to one expense account. Then at month-end, you do a journal to move the cost to each department. Every month, the same thing. You can stop doing that. Business Central can split the cost for you when you post the purchase invoice , using an Allocation Account . Quick answer Set up an Allocation Account once, with your split (e.g. 50% / 20% / 30%) and the department for each share. On the purchase invoice line, choose it in the Allocation Account No. field. Post. BC splits the amount to each department automatically. No journal needed. Before and after Before: every month ▼ Post purchase invoice full amount to one account ▼ Create a journal reclass the cost to each department ▼ Cost split (and repeat next month) After: Allocation Account ▼ Post purchase invoice Allocation Account No. = UTILITIES ▼ Cost s...

Reverse a Wrongly Posted Payment in Business Central (Open or Closed Month)

A customer or vendor payment was posted wrongly in Business Central: wrong amount, wrong bank, posted twice, or it never happened at all. Now you need to undo it without messing up the vendor balance, the bank reconciliation, or a month that Finance has already closed. Quick answer Payment's month still open → Reverse Transaction from General Ledger Entries. BC reverses everything on the original date. (Method 1) Payment's month already closed → post a reversal journal dated in the current month, then apply it to the original payment. (Method 2) Either way: unapply the payment from its invoice first, and clear the two bank entries in your next bank reconciliation. First, do you really need to reverse? Reversing is for a payment that is wrong as a whole. Smaller mistakes have a cleaner fix: What's wrong Best fix Only the dimension (e.g. wrong department) Correct Dimensions on General Ledger Entries. Nothing is reversed. Wrong vendor or customer...