Balance Sheet in SAP Business One

A balance sheet or statement of financial position is a summary of the financial balances. Assets, Liabilities and ownership equity are listed as of a specific date, such as the end of its financial year. A balance sheet is often described as a “snapshot of a company’s financial condition.

To open the SAP Business One Balance Sheet window, choose Financials -> Financial Reports -> Financial -> Balance Sheet.

Alternatively, open it from the SAP Business One Reports module.

 

 

 

 

 

 

 

 

 

 

You can either run the SAP Business One balance sheet according to a posting date or document date. Then specify the date which you would like to run the report. This is usually the current date; therefore it is automatically filled with the current date but may be changed according to preference.

 

 

 

 

 

 

 

 

 

 

Under Display and report:

Choose one of the following:

 

Accounts with Balance of Zero – report will include accounts with a balance of zero

Foreign Name – report displays the foreign names defined for G/L accounts.

Nothing is displayed for accounts which foreign names were not defined.

External Code – report displays external codes defined for G/L accounts.

 

Add Journal Vouchers – Includes transactions that are recorded in Open journal vouchers, but not yet permanently saved in the database.

 

You can also check the box for add closing balances, in order to add all the closing balances

Ignore Adjustments – Check this box if you would like to exclude adjustment journal entries from balance calculation

 

 

 

 

 

 

 

 

 

 

Specify whether to calculate the SAP Business One Balance Sheet for the entire year (Annual), or distribute according to months, quarters, or posting periods.

 

Choose segments:

You can select if you want to view the SAP Business One Balance Sheet report into segments by clicking on choose segments, the three different segments being: Division, Region and Department.

 

 

 

 

 

 

 

 

 

 

 

 

After you have clicked ok, it should pull out your SAP Business One Balance Sheet report, as displayed below:

 

 

 

 

 

 

 

 

 

 

 

The SAP Business One Balance sheet report has five levels depending on how you chart of accounts are set up; you will choose which level you want to view on the report.

Level 1: is the drawer level on your chart of accounts, the higher the level the more detailed the report will be.

Example of how a level one report looks:

 

 

 

 

 

 

 

 

 

 

 

Level four: