In addition to in-app statements, there are several other exportable reports in Ambrook to help as you review.

Most of these reports can be exported into .csv, .xlsx, or .pdf formats by clicking the download button. The available formats depend on the report. For example, the General Ledger exports as .csv or .xlsx. You can also hit CTRL+P to quickly produce a printable version of the report from the in-app version of the report.

Where to find exportable reports

Go to Settings > Export.
Scroll to the section you need, or type a report name into the search box at the top of the page to jump straight to it.

You can also reach the same Export page from Reports in the left sidebar by clicking the Export tab at the top of the page, alongside Profit & Loss, Balance Sheet, and Reconciliation.

Reports on the Export page are grouped into six sections: Popular, Tax Prep, Invoices, Bills, Items, and Other. A summary of what each report is used for and what’s included is in the tables below.

Finding the Invoices and Invoice Aging reports

Go to Settings > Export, then scroll to the Invoices section (or search for "invoice"). That section contains Invoices, Invoice Aging Summary, Income by Customer, Customer Statement, and Customer Balance Details.

Use the Invoices report when you want a full list of the invoices you’ve entered. Filter by Customer or Status, and customize which columns are included, in the download dialog.

Why future-dated invoices may not appear on your P&L

The P&L builds one column per period across the date range you select, and it leaves out periods that haven’t started yet. If you set the range to a full year, months that are still in the future are skipped, so an invoice dated in one of those months isn’t counted in the totals until that period begins.

To see invoices you’ve entered regardless of date, use the Invoices report on the Export page.

Report Name	Use Case	Options
Profit & Loss	Printable P&L for loan applications, grants, or year-end review with your accountant.	Filter by date range, cash or accrual basis. Reports by month, year, or quarter. Export enterprise P&Ls. Choose a Summary or Detailed report. The Detailed report lists each transaction line, including its Internal Notes.
Balance Sheet	Printable balance sheet for loan applications, grants, or year-end review.	Filter by date range and select cash or accrual basis. Reports by month, year, or quarter. Choose a Summary or Detailed report. The Detailed report lists each transaction line, including its Internal Notes.
Market Value Report	Printable report to generate a balance sheet that shows the market value of your inventory or other asset accounts, while still storing the cost-basis for accounting purposes. Customers on Pro can add a market value per inventory item, while customers on Build can add a market value for asset accounts without quantity/per item tracking.	Export the report as of any date, and update the market value of any asset accounts on your balance sheet.
Statement of Cash Flows	Cash flow statement for general reporting.	Filter by date range.
Transactions	Detailed list of all transactions.	Filter by account and category for detailed review.
Receipts	Review of all uploaded receipts.	Filter by date, vendor, amount, tag, contact, match status, and more.
Category Totals by Month	Monthly summary of income and expense categories.	Filter by date range and enterprise.

Tax Prep

Report Name	Use Case	Options
Schedule F Breakdown	Year-end tax form for agricultural businesses	Select date range, cash or accrual basis, and summary by Schedule F box or detailed by category.
Schedule C Breakdown	Year-end tax form for sole proprietors	Select date range, cash or accrual basis, and choose summary or detailed view by category.
1099 Payments	Vendor payments by 1099 box (1099-NEC and 1099-MISC). Filter to vendors where 1099-NEC or 1099-MISC filing is required.	Select a payment date range and choose which vendors to include. Export as CSV or Excel.

Invoices

Report Name	Use Case	Options
Invoices	Detailed information on invoices, including by customer, unpaid, or by date.	Break down by line items or payments. Filter by Customer or Status. Customize columns included in the export.
Invoice Aging Summary	Summary of overdue and outstanding invoices by time bucket.	Filter by customer and due date. Group by 30/60/90+ day aging.
Income by Customer	Summary of income earned from each customer.	Filter by date range and cash or accrual basis.
Customer Statement	Send your customers a report showing the invoices they owe you, payments that have been applied, and the total amount due over a selected time period.	Filter by customer and date range.
Customer Balance Details	Review outstanding balances by customer.	Select specific customers or view all.

Bills

Report Name	Use Case	Options
Bills	Useful for preparing custom reports.	Customizable by line item or payment detail, filters, and columns.
Bill Aging Summary	Summary of overdue and outstanding bills by time bucket.	Filter by vendor and due date. Group by 30/60/90+ day aging.
Expenses by Vendor	Total spending per vendor.	Filter by date and cash or accrual basis.
Vendor Statement	Track the bills you owe vendors, what you’ve already paid, and the total amount due.	Filter by vendor and date range.
Vendor Balance Details	Review unpaid bills by vendor.	Select specific vendors or review for all.

Items

Report Name	Use Case	Options
Inventory Item Register	Use this report to track how each inventory item’s quantity and value change over time, with a running balance that reflects all related activity.	Export a summary or detailed CSV by item or inventory account, filtered by item selection and date range, to review transaction-level quantity and cost changes with running balances.
Purchases by Item	Track your purchases by item(s).	You can include archived items and select any number of items from your Items list to generate a report. On the Pro plan, you can also include inventory-only items.
Sales by Item	Track your sales by item(s).	Export a summary or detailed CSV by item. You can include archived items and select any number of items from your Items list to generate a report. On the Pro plan, you can also include inventory-only items.

Other

Report Name	Use Case	Options
General Ledger	Full transaction-level report for all accounts, with starting and ending balance. See What’s included in the General Ledger export below.	Filter by date range and cash/accrual basis. Optionally sort by account code. Export as .csv or .xlsx.
Categories	Master list of income and expense categories.	View category names, types, description, and associated tax boxes
Chart of Accounts	Full list of balance sheet accounts and categories	View account types and names
Contacts	List of vendors and customers in the system, along with their contact information	View contacts and filter by vendor vs. customer status in the report
Trial Balance	Review all account balances in one place and confirm that total debits and credits are balanced across your books	Export the report as of a specific date to validate account balances at a point in time
Wallet Statement	Summary of Ambrook Wallet activity, including payments sent and received.	Filter by statement month

What’s included in the General Ledger export

The General Ledger lists every account in your books. For each account it shows a Starting Balance row, one row per transaction line in the selected date range, and an Ending Balance row.

Each transaction line includes these columns:

Column	What it shows
Account	The account or category the lines belong to (shown as a heading row for each account)
Date	The date of the transaction line
Description	The transaction’s description
Amount	The amount of the line
Split	The other side of the entry (the offsetting account or category)
Balance	The running balance for the account

Internal notes are not included in the General Ledger

The General Ledger export does not include a transaction’s Internal Notes, and you can’t add extra columns to it today. If you (or your accountant) use internal notes as extra descriptions and need to see them in a report, use the Detailed versions of the Profit & Loss and Balance Sheet instead. Both include an Internal Notes column.

Detailed Profit & Loss covers your income and expense categories.
Detailed Balance Sheet covers your asset, liability, and equity accounts.

Neither report matches the General Ledger on its own, but together they contain the same transaction lines, plus internal notes.

To export them:

Go to Settings > Export.
Click Profit & Loss, choose your date range and basis, and select Detailed as the report type.
Choose your format (.csv, .xlsx, or .pdf) and download.
Repeat for Balance Sheet, again selecting Detailed.

Tip: Grouping by month, quarter, or year isn’t available when you pick the Detailed report type.

Exportable Reports