Balance Sheet Report

Overview

The Balance Sheet Report flow is a dynamic spreadsheet report of your company’s assets, liabilities, and equity. This flow will generate a spreadsheet that shows your balance sheet data broken down into accounts.

With this flow you will be able to:

Ensure that your assets, liabilities, and equities balance

Compare monthly, quarterly, and yearly income and expense data

Control the start and end date of the report

Never have to export data from your accounting app again

Included Sheets

The Balance Sheet Report sheet is where you will find the report itself. Here you will see a chart summarising your assets, liabilities, and equity, as well as a balance sheet table with your data broken down into accounts.

You will also find a “Report Filter”, which you can use to change the start and end date of your report, as well as what time increment you want to group your data by.

Balance Sheet Filtering

This sheet is an intermediary sheet that contains crucial formulas that power the Balance Sheet report. Please avoid deleting or editing this sheet/tab if you want to maintain the report's functionality.

Creating the report

To create the report, find the “Balance Sheet Report” flow in the gini webapp. Ensure you have connected the required apps - this flow requires at least one accounting app (either Xero or QuickBooks) and Google Sheets.

Then from the flow page, select the organisation you want to create the report for and click the “Create Report” button.

Once your flow is created, you will be able to find it in the “My flows” section of the dashboard. Click on the “Open flow” button to see the report in Google Sheets.

FAQ

My report has a few #REF! and/or #VALUE! errors. What should I do?

This can sometimes occur when you create a flow due to the complex nature of some formulas in the report. In such cases, a forced recalculation of formulas can often resolve these reference errors.

A simple way to force a recalculation is to use Google Sheet’s “Find and replace” function. Follow the instructions on the short tutorial below to try it yourself:

If this does not resolve your errors, please contact us for further help at help@gini.co.

Can I make edits to this report?

This report has many complex interdependencies between its sheets. Rearranging sections, moving cells, and adding new rows or columns can easily break the report.

We recommend only making edits to the cells designed to be changed based on your input, which include:

Dropdown cells

If you are looking for additional functionality on this report, please reach out to us at help@gini.co for feature suggestions.

Can I make copies of this report?

While you can make copies of the report to a new spreadsheet by using Google Sheet’s copy spreadsheet or copy sheets features, the newly generated copy will not sync with subsequent updates from your accounting app. Only the original report sheets in your gini spreadsheet will sync with your accounting app.