Profit & Loss Report
The Profit & Loss Report flow is a dynamic spreadsheet report of your company’s income and expenses. This flow will generate a spreadsheet that shows your profit and loss data broken down into accounts.
With this flow you will be able to:
- View your income and expense data broken down by accounts
- 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
- Create your own financial models that update automatically
P&L Report sheet is where you will find the report itself. Here you will see a chart summarising your revenue and net income, as well as a profit and loss table with your income and expenses 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.
This sheet is an intermediary sheet that contains crucial formulas that power the Profit & Loss 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 “Profit & Loss 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.
My report has a few
#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 email@example.com.
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 firstname.lastname@example.org 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.