SparkReceipt makes a Profit and Loss (P&L) for any date range: the Profit & Loss widget on the Overview shows your revenue, your expenses by Category and the net profit or loss. To print it or save it as a file, use Export on the Overview, which gives you an Overview summary as a PDF and an Excel file. SparkReceipt does not make a Balance sheet. It records your income and expense documents, and it does not keep track of assets, liabilities or equity, which a Balance sheet needs.
Where the Profit and Loss comes from
The P&L adds up your Expense and Income documents by their document date, in your account's home currency. Income documents show as Revenue, expenses are listed by Category, and the widget ends with Total Expenses and Net Profit / (Loss). Lines on a bank statement count only once they are matched to a receipt or turned into an entry. See Why aren't my bank statement transactions showing in my reports?
See Using the Overview screen for the widget's Include Tax and Projection options.
Print or download the Profit and Loss
In the web app:
- Open Overview and choose the date range at the top, for example Last Month or This Year, or pick your own dates.
- Click Export.
- The Export overview dialog shows that you get a PDF and an Excel file, downloaded together as a ZIP. Change the Report name if you like and click Export.
- Open the PDF and print it, or send it on.
You can also create the same file in Reports > Create report: under Select what kind of report you want to create, choose Overview summary and set the dates.
In the mobile app: on the Home tab, tap Export next to the time period. The Create Report view opens with the Overview summary and the period's dates filled in. Check them and create the report.
The Overview summary has these sections, as tables:
- Profit and loss: Income, Expenses and Net profit or loss
- Cash flow: income, expenses and net cash flow by week for a period of up to about three months, and by month for longer periods
- Expenses by category and Income by category
- Document types and Review status
- Spending by user, when your role can see it on the Overview
Amounts include tax and are in your home currency. Projected amounts from recurring automations are left out, so the file shows what has actually happened. The file has tables only. The Overview's charts are not in it, and SparkReceipt has no report with pie charts.
Monthly and annual Profit and Loss
Pick the period you need as the date range: a month for a monthly P&L, or a full year (for example January 1 to December 31, or your own financial year) for an annual one. There is no separate "monthly" or "annual" report.
To see months side by side for a longer period:
- Export an Overview summary for the whole period. Its Cash flow table has one row per month when the period is longer than about three months.
- Or create a standard report and set Break totals down by period to Monthly. It adds a row per month with the Subtotal, Taxes and Total for expenses and for income. See How to create reports in SparkReceipt.
Printing documents and the Overview
SparkReceipt has no print button of its own. To print, download a PDF and print it from your computer or phone:
- the Overview or a P&L: Export on the Overview, as above
- a single receipt or invoice: open it in the web app and use Download and then Download as PDF
- many documents: Export on Documents with the PDF format, and tick Include receipts in the PDF to add the receipts after the report pages
If you need a Balance sheet
A Balance sheet is prepared in accounting software or by your accountant. SparkReceipt can publish your expenses and income to accounting software such as QuickBooks Online and Xero. See What accounting software integrations do you have? You can also invite your accountant to your account so they can work from your documents.