Small and medium business | Business Central, N...

Importing GL Opening Balances

(0) Share

Report

Posted on by abutler1986

677

Hi All,

I am still having major issues getting balances into Business Central via Config packages.

Please can someone confirm the following to make sure I am on the right track and to see if there are any settings I have missed?

- Table numbers to import opening balanced

- Settings need to be setup before imports

- Is there any link tables needed to be added when you select the table to be imported into using the config package like it usually suggests

Any help appreciated

Andrew

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

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

Like (0)

Report

For importing to general journal, you just need table 81 Gen. Journal Line.

It depends on how many data you have, but what I normally do is copy and paste from excel to the journal directly.

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

Thanks Teddy.

Which way would you usually do things, would you get all the balanced imported for the GL first then import the transactions as journals for Sales and Vendors after?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Either way is fine. Normally GL is done first because my clients gave me that first.

Just make sure when you do the sub-ledgers, it does not effect the GL opening balance.

It is easier when you do sub-ledgers first because you can confirm easily that all the trial balance is zero prior to GL opening balance.

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

Ok assume I do the GL opening balances first, these will probably have the totals inclusive of the transactions for the sub ledgers though so how do you exclude them if that makes sense?

Can you also provide detail in regards to historical transactions? I have lists sent to me which they wish to be on the system as well, is this possible?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

when you are doing the subledger, you need to put the corresponding GL account as the balance so it will do a plus minus on the same account.

If you want an example, on the General Journal, you can click on Actions > Opening Balance > Prepare Journal > Customers Opening Balance.

It will give you an idea on how to do the opening balance.

For historical transactions, it will be more difficult. Because you need to import it using journal and also apply the payment and invoice to each other. I normally don't recommend historical transactions. If needed, you can import it to separate database (sql, etc) and do the analysis there.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

Hi

I am currently doing this with a client. They are bringing historical detail for GL and AP (I also don't recommend, but it is what they want). We are loading everything as journals EXCEPT supplier payments and credits. Those I am bringing in as if they are bank transactions and using auto-apply to apply as we go. That will at least take care of the majority of applications.

To upload, we are just using the "Edit in Excel" feature, copying over and publishing.

Cheers

Heather

Was this reply helpful? Yes No
abutler1986 677 on at

Like (0)

Report

Hi Both,

Has anyone experienced the below error message before? Trying to get the first load of Vendor transactions in but cannot find where this is pointing too.. I am sure all the tax fields are complete..

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Just filter your journal for DOMESTIC and blank, you will be able to find roughly the journal

Was this reply helpful? Yes No