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

Take on balance

(1) Share

Report

Posted on by MC-30050807-0

Hi guys i want to post opening balances in my new company, so i have the trial balance with dr and cr balances, so how do i put them in my new company. So on my journal how do cater for debits and credits and balancing accounts since in my environment there are no debit and credit fields

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,547 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi

I hope this can help you and give you some hints

A Strategy for Opening Balances in Business Central - Dynamics 365 Business Central (usedynamics.com)

Easier to create opening balances for item tracked inventory | Microsoft Learn

Dynamics 365 Business Central – How I post Opening Balances for Bank Accounts (thedynamicsexplorer.com)

BR

Gr

Was this reply helpful? Yes No
MK-19060840-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please use the -sign for credit balance and +sign for debit balance, then upload the TB.

Note: The total values should be zero.

Regards,

Madhan

Was this reply helpful? Yes No
Suggested answer

KR-19060856-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please follow the steps for the Opening Balance import for the Company:

1. Create Journal batch for Vendor, Customer, Item and Bank and Fixed Assets and G/L Values

2. Export the Templates through configuration package and fill the data you want import in the Journal.

3.Import the Vendor Balances, customer Balances, Bank Balances and Fixed Assets through configuration package. For each template you need to mention the Journal batch

4. Once imported the value through template, please validate and apply the package to insert the values into the gen journal.

5. Verify the imported value in the General Journal and Post the journal

When entering the values in the template, enter '-' symbol for Credit balance and without '-' as consider as debit balances.

Regards,

Kasthuri

Was this reply helpful? Yes No
MC-30050807-0 54 on at

Like (0)

Report
Copy link

Link copied!

@ Kasthuri & Madhan 1:SO I DONT NEED THE BALANCING ACCOUNT ON MY JOURNAL?
screnario 2:HOW ABOUT IF I DONT WANT TO INCLUDE OTHER ACCOUNTS AS OF NOW! IT WONT HAVE A ZERO BALANCE SINCE THE DR & CR WONT BE BALANCING

Was this reply helpful? Yes No
Suggested answer

Tarik Jerkovic 111 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to use Personalization or Designer mode to add or show column with debit amount and credit amount in Journals.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,962 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

1:SO I DONT NEED THE BALANCING ACCOUNT ON MY JOURNAL?
screnario

For a trial balance typically no, you wouldn't have a balancing account on each line. The lines summed up together will balance or sum to zero.

2:HOW ABOUT IF I DONT WANT TO INCLUDE OTHER ACCOUNTS AS OF NOW! IT WONT HAVE A ZERO BALANCE SINCE THE DR & CR WONT BE BALANCING

The trial balance needs to balance or sum to zero. Can you expand on why you're not including all accounts?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No