Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Take on balance
Small and medium business | Business Central, N...
Suggested answer

Take on balance

(1) ShareShare
ReportReport
Posted on by MC-30050807-0 54
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
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,250 Super User 2024 Season 2 on at
    Take on balance
      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?
     
  • Suggested answer
    Tarik Jerkovic Profile Picture
    Tarik Jerkovic 92 on at
    Take on balance
    Hi,
     
    You need to use Personalization or Designer mode to add or show column with debit amount and credit amount in Journals.
     
     
  • MC-30050807-0 Profile Picture
    MC-30050807-0 54 on at
    Take on balance

     @ 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
  • Suggested answer
    KR-19060856-0 Profile Picture
    KR-19060856-0 6 on at
    Take on balance
    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
     
  • MK-19060840-0 Profile Picture
    MK-19060840-0 6 on at
    Take on balance
    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 
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 13,116 Most Valuable Professional on at
    Take on balance

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans