Balance Sheet (Experimental)

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

Prerequisites

View Requirements here

What the Report Does

The Report shows key financial and transactional data, including dates, invoice numbers, customer information, descriptions, and monetary amounts, enabling users to track and analyze invoicing activity and totals for 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.