Trial Balance Issue - Business Central

(0) Share

Report

Posted on by Daniel Huntley

Hi, we are wanting to run a trial balance at our year-end, however, it doesn't seem to be picking up our opening balances (e.g. customer - Aged Debtors) that we have imported from our previous Sage system the year before. Are we doing something wrong?

Help!

Regards

Dan

Categories:

Financial Management

I have the same question (0)

All responses (14)

Answers (7)

ManishS 86 on at

Like (0)

Report

Are you looking at Customer Trial Balance or Financial Trial Balance.

How have you imported the opening balance ? Are the balance appearing both in customer ledger and GL ledger.

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report

Thanks for the quick response.

Its the Trial Balance report in Reports and Analysis, so financial. It seems to be only the aged debtors and creditors that are way out. When I run a detailed trial balance for these G/Ls only, all the opening balances are double entered and balance to zero? and then start to accrue once the invoices.

I used the Opening Balance menu item in General Journals (Customer and Vendor). The balance appears correctly in customers and has since been matched to a payment successfully (see attached example).

Regards

Dan

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report

Sorry to add:

The customer opening balances appear once in Customer Ledger and twice (double entry) in the accounts receivable ledger (cancelling each other out).

Thanks

Dan

Was this reply helpful? Yes No
Verified answer

Heather Roggeveen 9,146 on at

Like (1)

Report

Hi Daniel

I am new to BC, so was interested in your thread and looked at what mine looked like for the database I am playing in. I also imported my opening balances as an opening balance journal. I used the AR control as the offset account - so also am showing in and out in the control account.

But then in applying what I did for implementations in Dynamics GP, I realised that that is what I would expect to happen - because you also bring in the GL Trial balance.

These are the steps I do:

Import GL trial balance as at end of each month (or just end of the period prior to my first period in a new system). Those GL balances include an AR control balance.

Import AR opening transactions - but I don't want these to add to the AR control total - so I have both the DR and CR to AR control - the in and out.

Check my AR trial balance agrees with the GL balance.

An alternative way to do it would be to do the same steps - BUT in the GL trial balance, change the AR control account code to a clearing account. Then when bringing in AR opening balances, use the clearing account as the offset. Then you will get the clearing account going to zero and the AR control reflecting the transactions you just brought in.

Does that make sense?

Cheers

Heather

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report

Thank you so much for the detailed response!

To be honest, I am not getting it 100%

- Import GL trial balance as at end of each month (or just end of the period prior to my first period in a new system). Those GL balances include an AR control balance.

So this process is what I did with my Sage 50 closing balance which was - I imported via journal with CR to my Customer Account(s) and DR the Accounts Receivable GL for each customer balance.

- Import AR opening transactions - but I don't want these to add to the AR control total - so I have both the DR and CR to AR control - the in and out.

This is the part I am not clear, is this a new journal entry, if so how would it look in a journal?

Thanks again.

Dan

Was this reply helpful? Yes No
Verified answer

BenSydney 32 on at

Like (1)

Report

It looks like you have only posted your Customer opening documents/balances, coded to the Debtors Control account (resulting in the dr and cr to the same account - which is correct).

It doesn't look like you have imported your GL opening balances. This is usually a separate journal and your closing TB from your old system. This journal will post the opening value of the Debtors Control account.

Regards,

Ben

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report

Thanks for the message, so a sperate journal for both AR and AP (and any others ) balancing to a (new) Opening Balance/Suspense (GL). Would this work? Thanks

Was this reply helpful? Yes No
Daniel Huntley 45 on at

Like (0)

Report

sorry...but would you be able to clarify this step:

- It doesn't look like you have imported your GL opening balances. This is usually a separate journal and your closing TB from your old system. This journal will post the opening value of the Debtors Control account.

I have my opening TB from Sage, I have created two G/Ls (see attached), could you confirm the balancing account for the Debtors Control account (AR) and Creditors Control account (AP), will be the 90000 Opening Balances account?

Thanks

Dan

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

the basic idea is basically to import AR and AP balances without effecting the general ledger entries, because the general ledger entries' value will be imported during the GL opening balances.

there are two ways you can do to import AR or AP balances:

1) Create journal and post it as normal which will create general ledger entries. You will then need to create a general journal to reverse it only on the general ledger entries side (not the customer or vendor ledger entries)

2) Create journal, but post it to the same account so it will do positive and negative to the same account. You don't need to create reversal journal for this.

Was this reply helpful? Yes No
Verified answer

BenSydney 32 on at

Like (0)

Report

Hey,

Usually you will load the full TB from your old system, and therefore you will not need to use a 'balancing' account. The full TB from your old system should be in balance (total of all the accounts should zero).

How are you doing the GL opening balance load for the other accounts (bank accounts, inventory, fixes assets, retained earning, etc.)

Regards,

Ben

Was this reply helpful? Yes No