How to map the Final Accounts Layout?

Created by Jason Margahal, Modified on Tue, 8 Jul at 5:23 PM by Jason Margahal

A2000 ONLINE SUPPORT DEPARTMENT

KNOWLEDGE BASE

DESCRIPTION: The Final Accounts Layout function refers to the feature that enables users to structure, format, and generate core financial statements directly from the system based on the accounting data entered.
_________________________________________________________________________________________________________________________

Question: How to map the Final Accounts Layout?

Answer: Final accounts layout is use to set your Balance sheet and Profit & Loss ‘classification reports’. 

Here are the basic steps:

1.  In Finance> Ledger> Settings> Final Accounts Layout

image.png
_____________________________________________________________________________________________________________________________________

2.  Fill the above levels base on your preference that will be reflected in your BS Classification report:

         Level 1: eg. Header: NON-CURRENT ASSETS and Footer: NET BOOK VALUE
         Level 2: eg. Header: PLANT, PROPERTY & EQUIPMENT and Footer: TOTAL
         Level 3: eg. Description: FURNITURE & FITTING – AT COST, Print: Debit Balance,  Profit: No Profit, Stock: Non              Stock and Category: Trading
_____________________________________________________________________________________________________


3. After filling the final accounts layout, you may map to corresponding Chart of account code:

       ·         FINANCE > LEDGER > SETTINGS > CHART OF ACCOUNTS
·         Search for the exact Chart of Accounts. Eg., 1010 – FURNITURE & FITTINGS – AT COST

image.png

·         Click the COA and system will prompt you the below screens:

image.png

image.pngNote: Ensure that the classification levels in the sample Chart of Accounts are aligned with the levels configured in the Final Accounts Layout.
_____________________________________________________________________________________________________


4.  Preview the Balance Sheet Classification Report.

FINANCE > LEDGER > REPORT QUERIES > REPORTS & QUERIES for the screen below:

image.png

image.png
_____________________________________________________________________________________________________________________________________

After configuration below is the Balance Sheet Classification preview output:

image.png
_____________________________________________________________________________________________________________________________________

For configuration of Profit and Loss Classification Report under Final Accounts Layout below are the steps:

1.    Fill the below levels base on your preference that will be reflected in your Profit and Loss Classification report:

image.png

          
          Level 1: eg. Header: Ordinary Income/Expense and Footer: Gross Profit
          Level 2: eg. Header: Income and Footer: Total Income
          Level 3: eg. Description: Sales, Print: Credit Balance, Profit: No Profit, Stock: Non Stock and Category: Trading
____________________________________________________________________________________________________


2.  After filling the final accounts layout, you may map to corresponding Chart of account code:

                ·         FINANCE > LEDGER > SETTINGS > CHART OF ACCOUNTS
                    ·         Search for the exact Chart of Accounts. Eg., IC0010 – Sales

image.png
_____________________________________________________________________________________________________________________________________

3. Click the COA and system will prompt you the below screens:

image.png

·         Ticked the box for 100% composition in P&L Classification

image.pngNote: Ensure that the classification levels in the sample Chart of Accounts are aligned with the levels configured in the Final Accounts Layout.
_____________________________________________________________________________________________________


4. Preview the Profit and Loss Classification Report.

FINANCE > LEDGER > REPORT QUERIES > REPORTS & QUERIES for the screen below:

image.png

image.png

After configuration below is the Profit and Loss Classification preview output:

image.png


* END * 

* END * 



Disclaimer: The information provided here is provided on an as-is basis without warranty of any kind, either expressed or implied, including warranties of merchantability and fitness for a particular purpose. In no events shall A2000 Solutions Pte Ltd or its agents, distributors and suppliers (collectively known as A2000) be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if A2000 have been advised of the possibility of such damages. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. All third party trademarks are the property of their respective owners.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article