Template Reconciliation
The Template Reconciliation report shows every journal entry line Bookkeep built for a date range, rolled up by account type across all of your connections and templates. Each account type group opens into the account lines that make it up, each account line opens into the connection and template it came from, and where a template breaks a line down further (for example gross sales by product category, or sales tax by jurisdiction) those rows sit underneath.
It is built for accountants who cannot see the source platforms themselves. In one place you can confirm what Bookkeep posted for the period, see that the entries balance, and see which days a connection produced no entry at all. It works for every app and every template Bookkeep supports, because the rollup uses each template line's default account type rather than anything specific to a platform.
Template Reconciliation replaces the Bookkeep Summary Report, which is being retired. Both read the same journal entries, so the amounts reconcile line for line. The difference is scope: the Summary Report shows one template of one app at a time, while this report combines every connection and template into a single tree and adds the balance check, missing-entry tracking, and a flat export.
You'll find the report in Bookkeep by clicking Reports in the left navigation menu, then choosing Template Reconciliation under the Bookkeep section.
How the report decides what's included
- Every journal entry whose summary date falls inside the date range counts, from every connection and template you have selected, in the currency you have selected.
- Entries count regardless of posting status, so an entry that failed to post or is waiting to post still contributes to the totals. This matches the Bookkeep Summary Report, which is why the two reconcile.
- A template line contributes to the tree only when its template defines that line. Amounts in an entry that the template has no line for are not shown.
- Connections on apps that are not yet live are hidden unless you are viewing as a Bookkeep admin.
Filters
Changing any filter reloads the report and updates the page address, so you can bookmark or share a filtered view.
| Filter | What it does |
|---|---|
| From / To | The date range, inclusive. Defaults to the current month through yesterday. On the first of a month it defaults to the whole previous month. |
| Connections | One or more connections. Defaults to all of them. Connections are grouped by app. |
| Templates | One or more templates. Defaults to every template mapped on the selected connections. |
| Currency | The currency to report in. Entries in other currencies are excluded from the amounts. Defaults to the first currency your entity has posted in. |
Totals
A line above the boxes gives the context for the view: how many journal entries, how many mappings across how many connections, how many missing days, the currency, and the date range.
Below it there is one box per account type, showing that type's net total for the period and the number of account lines inside it. Account types appear in a fixed order: Income, Cost of Goods Sold, Expense, Bank, Other Current Asset, Other Current Liability, then any others alphabetically, with Uncategorized last.
Each total is netted in the direction that is normal for the type:
- Income, liabilities and equity show credits minus debits. Income therefore reads as net sales: gross sales and shipping income less discounts and returns.
- Assets, bank, expenses and cost of goods sold show debits minus credits.
Balance check
Under the boxes, a Balance check card adds up the credit-side types (income, liabilities, equity) and the debit-side types (assets, bank, expenses, cost of goods sold) and shows the difference. Because every journal entry balances, the two sides must be equal. The card is green when the difference is zero and red when it is not, and it names the types on each side, for example:
Income + Other Current Liability $2,279,851.95 = Other Current Asset $2,279,851.95 → Difference $0.00
A non-zero difference means something in the selected entries does not balance. Narrow the connection and template filters until the difference disappears to find where it comes from.
Template lines with no default account type are grouped as Uncategorized, shown last. They have no normal balance to net against, so they sit on neither side of the check; when any are present the card says how many lines and how much was left out.
Missing entries
When any selected connection is missing a day, an amber Missing entries panel lists each connection and template with the number of days and the dates themselves. The same count appears in the Missing days column on the connection rows in the table.
- A day counts as covered when the connection has a posted or a pending entry dated that day. A failed entry does not cover its day.
- Counting starts on the day the connection's mapping was created, so a connection added mid-month is not flagged for days before it existed.
- Only enabled mappings are checked. A paused mapping has no expected days.
- The currency filter does not apply here. An entry in any currency covers its day.
Templates that do not produce an entry every day, such as payout or settlement templates that post only on days a payout occurs, will show their off days as missing. Read the panel with the template's schedule in mind.
The table
The table is a tree with four levels:
- Account type, such as Income, in bold with the netted total.
- Account line, such as Shopify Gross Sales, with its posting side and total. Lines are rolled up across every connection and template that posts to the same default account with the same posting side.
- Connection · template, one row per mapping that contributed to the line, with the entry count and missing days for that mapping.
- Detail rows, where the template breaks the line down, such as product categories under gross sales or jurisdictions under sales tax.
Account type groups start open and connection rows start closed. Use Expand all and Collapse all above the table to open or fold every level at once.
| Column | What it shows |
|---|---|
| Account | The type, account line, connection and template, or detail label, indented by level. |
| Dr / Cr | Whether the account line posts as a debit or a credit. Blank on account type rows. |
| Entries | How many journal entries contributed to the account line or connection row. |
| Missing days | On connection rows only: the number of days in the range with no entry for that mapping. |
| Amount | The total in the selected currency. Account type rows show the netted total; every other row shows the amount as it was posted. |
Filter lines narrows the tree as you type. A row stays visible when its own name, any row above it, or any row below it matches, so typing a product category shows the path down to it, and typing a connection name shows everything under that connection. Clear the box to return to the default view. You can also reorder, resize, and show or hide columns from the Columns menu; those choices are remembered in your browser.
Exporting
Download CSV exports the current filters as a flat file, with the on-screen line filter applied if you have typed one. It is designed to be read by a spreadsheet or handed to an AI tool, so every row carries its full context:
| Column | What it holds |
|---|---|
row_type | type, account, mapping, or detail, matching the four levels of the tree. |
account_type | The account type the row belongs to. |
account, posting_type | The account line and its posting side. Blank on type rows. |
connection, provider, template | The connection, its app, and the template. Blank above mapping level. |
detail | The subcategory or child label. Filled on detail rows only. |
amount, currency | The row's amount and the report currency. |
from_date, to_date | The date range of the export. |
journal_entry_count, missing_count | The entry count and, on mapping rows, the missing days. |
Rows appear in the same order as the tree, so account type and account totals are their own rows rather than being repeated on each line. Filter on row_type to keep only the level you need. After a blank line, a second block lists every missing day as connection, template, missing_date.
The Bookkeep Summary Report renames some lines for display, for example showing "Gross Sales" for any sales line and adding "Issued" or "Redeemed" to gift card lines. Template Reconciliation shows each line under the template's own default account label, such as "Shopify Gross Sales", and uses the Dr / Cr column to tell debit and credit lines apart. The amounts are identical.