Ambrook has multiple in-app reports used for reviewing transactions, including the Profit and Loss and Balance Sheet reports. These reports allow a user to click into any date and account or category to bring up a subledger of all transactions for that time period. Accountants and bookkeepers use these tools to review accounts, find errors, and correct as they go. Both reports are available on a cash and accrual basis. A full video walkthrough of these reports is here.
In addition to in-app reports, there are many more reports that can be exported and manipulated in Excel. A summary of these reports is below, and a full list is here.
Report Name | Use Case | Options |
Profit & Loss | Printable P&L for loan applications, grants, or end of year review with your accountant. | Filter by date range and select cash or accrual basis. Get reports by month, year, or quarter or export enterprise P&Ls. Use Display options to round amounts, hide zero-value rows, or sort rows (see below). |
Balance Sheet | Printable balance sheet for loan applications, grants, or end of year review with your accountant. | Filter by date range and select cash or accrual basis. Get reports by month, year, or quarter. Use Display options to round amounts, hide zero-value rows, or sort rows (see below). |
Invoices | Detailed information on AR and invoices. Useful for preparing custom reports. | Break invoices down by line items or payments. Apply filters such as Customer or Status. Customize columns included in the export. |
Bills | Detailed information on AP, bills. Useful for preparing custom reports. | Break bills down by line items or payments. Apply filters such as Customer or Status. Customize columns included in the export. |
Aging Reports | Outstanding amounts and days for invoices and bills | Select specific contacts or review for all contacts, AR or AP specific. |
Customer and Vendor Statements | Send your contacts a summary of their account activity, including invoices or bills, payments or credits that have been applied, and the total amount due. | Filter by contact and date range. |
1099 Payments | Tracking 1099 vendor expenses. | Filter by payment date range. |
Statement of Cash Flows | Cash flow statement for general reporting. | Filter by date range. |
Transactions | Details of all transactions. | Can be filtered by account and category for detailed review. |
Schedule F Breakdown | Year-end tax review. | Select date range, cash or accrual basis, and whether to include a summary by schedule F box or detailed that includes amounts per category. |
Display options for in-app reports
On the Profit & Loss and Balance Sheet, click the three-dot menu at the top right of the report to open Display options:
Round amounts: round figures to the nearest whole dollar.
Hide zero-value rows: hide accounts or categories with no values in any column.
Sort by account code: order accounts within each section by their account code, lowest to highest.
Sort by amount: order accounts within each section by amount, largest first, available on the P&L only.
When you download the P&L, Balance Sheet, Trial Balance, or General Ledger with Sort by account code turned on, the export uses the same order.
Setting account codes
Account codes come from the optional Number / Code / ID field on each balance sheet account and each category. Edit it from Accounts (for balance sheet accounts) or Settings → Categories (for categories). You don’t need a code on every account to use the sort.