Produce a balanced book depreciation entry for any month, or for the whole year, and take it out as a working paper or an import file.
Steps
Open a return and go to the Report tab.
Choose the Journal Entries template. The report opens on December.
Pick a period. The Period dropdown holds the twelve months of the tax year plus Full year.
Edit the JE reference if you want to. See below.
Export. Excel, PDF, or an import file for QuickBooks, Sage Intacct, or Xero.
If the Report tab shows Bonus elections need review before this report can compute, resolve that first. It blocks every template on the tab, this one included.
What the entry looks like
One row per GL account, closing with a totals row so you can check the balance without exporting.
Account | Account Name | Description | Debit | Credit |
6100 | Depreciation Expense | Book depreciation — March 2025 | 5107.07 | 0.00 |
1510 | Accum. Depr. — Equipment | Book depreciation — March 2025 | 0.00 | 5107.07 |
Totals | 5107.07 | 5107.07 |
On screen the side that does not carry the amount shows 0.00 rather than an empty cell. QuickBooks and Sage Intacct CSVs leave that side blank. Xero writes one signed Amount column instead.
The entry date is the last day of the selected period, shown in the card header.
A period with nothing in it reads No depreciation for this period. in place of the table.
The JE reference
The JE reference field starts at DEP-2025-03 for a month, or DEP-2025 for the Full year view. It is editable, holds up to 21 characters, and rides along into the Excel, PDF, and CSV outputs.
Changing the month re-seeds it, so type your firm's convention after you pick the period, not before.
Disposal entries carry their own references, generated rather than typed. See Disposal journal entries.
How the figures are computed
DepreciationPro charges book depreciation straight-line: depreciable basis divided by the useful life in months on the asset's book record. An asset is charged a full month in the month it is placed in service, and no depreciation in the month it is disposed of.
The twelve monthly entries add to the annual figure exactly. The Full year view is not computed separately and reconciled. It is the same numbers viewed differently.
Amounts tie to the book depreciation schedule to the penny, and each entry balances by construction. Rounding residue is carried rather than dropped, which is why the twelve months add up with nothing left over.
Excel and PDF
Excel and PDF in the Export menu give you the same entries as a working paper. The on-screen report, the edited reference, and the selected period all carry through.
Both stay available even when the CSV import file is blocked. Only the file that posts to a ledger is ever gated.