Balance Sheet

The balance sheet shows a company’s assets, liabilities, and equity at a specific point in time.

Prerequisites

1. Microsoft Windows 10 Pro, Windows 11 Pro, or Windows terminal server (2012 and above)
2. Microsoft Office 365
3. Sage 50 US edition (2021 and above) 
4. Internet connection

What the Report Does

The report shows key financial and transactional data such as dates, invoice numbers, customer information, descriptions, and monetary amounts, allowing users to track and analyze invoicing activity and totals over a selected period.

How to Use the Report

Step 1: In the Balance Sheet tab, put the date in D3.

Step 2: Click Refresh on the XLGL ribbon.

Step 3: Review the result in the Balance Sheet tab

Customization Options

1. Adjust the desired year in the Parameters sheet to generate data for a different period.
2. Add additional years to the Yearly sheet. To add a new year:
3. Copy column H (last year’s data).
4. Paste it into the desired column.

Common Use Cases

1. To review and monitor invoice activity per period
2. To analyze total invoice amounts and tax breakdowns
3. To track customer transactions and invoice details

Troubleshooting

Issue: No data is populated.
Solution: Verify that the input parameters are correct and that the selected date range contains existing records.

FAQs

Q: How can I see the account number?
A: Unhide column B to display it.

Best Practices

1. Save a backup copy of the Report before making significant changes.
2. Regularly review the report to track progress and identify trends early.
3. Customize the report to focus on key performance indicators relevant to your business.