Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a Trial Balance where I need to calculate the Opening and Closing Balance.
I did calculate the timeframes to be calculated as well as the Balance Amount with below definitions but I'm not able to get the previous month calculation. Please help !!!!
Solved! Go to Solution.
I fixed the inaccurate Debit and Credit amounts and finally I got the measures as following:
I fixed the inaccurate Debit and Credit amounts and finally I got the measures as following:
Thanks for the reply @DataNinja777 . Yeah you're right, they're not balanced. I'm using AX as my source.
Any insight to calculate the opening and closing balance ?
Hi I have never used AX before, but googling (or Bing-ing) indicates that it is Microsoft Dynamics AX. Is this correct? In that case, this is a well know ERP system which has various standard inbuilt reports which also include trial balance. You can of course download all the accounting bookkeeping journal entry records of debits and credits which should add up to zero since the implementation of this ERP system in order to build your hand-made trial balance using the logic of balance sheet GL accounts to cumulate for the lifetime, while cumulating PL GL for the current year only and recording the cumulative previous year PL GL balances in retained earnings GL account, but this is not necessary if you have a standard ERP which already can produce these standard reports. I found the link of how to get TB from Microsoft Dynamics AX's.
Trial balance report (LedgerTrialBalance) | Microsoft Learn
Unless you are using the excel to maintain your own bookkeeping transaction records, building of hand-made trial balance is not necessary because ERP or accounting system will be able to produce such standard reports.😉
In your visualisation screen print, the debit and credit balances have a difference of 5.5 million MXN. Bookkeeping cannot be posted unless debits and credits are balanced and entries recorded in all the GL accounts sums up to zero. Which ERP accounting system did you download the raw data from? As you know, balance sheet GL balances are cumulative sums of transactions since the creation of the GL, while PL account balances are total for the year for the GL, and previous year accumulated profits are recorded in retained earnings in sharehoulders' equity section. In order to prepare this using dax, the above logic needs to be reflected, but in most cases, trial balances are obtainable from ERP or accounting system which your company is using.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
11 | |
10 | |
8 |
User | Count |
---|---|
62 | |
20 | |
11 | |
11 | |
11 |