Skip to content
Bitta Apps

Bitta Sheets · Part 8 · 2:21 · YouTube

Business Central Consolidation: Review, Post, Reverse

What this video covers

Review a Business Central consolidation in a live workbook, post its eliminations with a preview first, and reverse them.

The six workbook tabs and Review changes, Post from the workbook or the Consolidation Posting Log, Block Posting On Exceptions, Preview Changes and Apply Changes, G/L Register and G/L Entries, Reverse Register, the Audit Trail, and the next period.

Transcript

The eliminations are reviewed. Now they go into the general ledger, and sometimes they need to come back out. Here's how to review a consolidation in its workbook, post the eliminations, and reverse them.

Review in the workbook. Post with a preview first. Reverse with Business Central's Reverse Register. The workbook has six tabs: companies, account mapping,

trial balances, eliminations, the consolidated statements, and an audit trail. Columns with a pencil write back to Business Central, and nothing is written until you review the changes and apply them.

Posting starts here, or from the Posting Log. While exceptions are open, it shows why it won't post. On the Posting Log, Post Eliminations gives the same answer: the intercompany mismatches block the posting.

The difference sits on the intercompany difference account, so you can post now and correct it later. Clear Block Posting On Exceptions on the card. Post Eliminations simulates first.

Preview Changes lists every line before anything is written. Apply Changes posts into the consolidation company only, through its consolidation journal batch, once per period. The log shows the document and its G/L register.

G/L Register and G/L Entries open what was posted: seven lines on the last day of the period. To take a posting back, run Business Central's Reverse Register on that register. It posts the correcting entries.

The Posting Log shows it reversed, and the period can be posted again. The Audit Trail keeps every change, with who made it and when: the block switched off and on, and every refused and simulated posting. When the period is done, Next period moves the workbook on.

Or open the consolidation for the next period from the wizard. Post once the review is clean and the period is final. Until then, review and simulate as often as you like. Next: financial reports by period.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data