Google Sheets Bookkeeping Template: Templates and Setup
A Google Sheets bookkeeping template works as a private copy with checked formulas, clear input fields and access limited to those reviewing the records.
Income: public sample
Fields from the original workbook. Filled rows are fictional examples; blank fields are for your records.
Reporting amounts use USD in this worked example. Dates use YYYY-MM-DD.
| Date | Reference | Company | Payer | Entry type | Amount | Account | Source | Signed income |
|---|---|---|---|---|---|---|---|---|
| 2026-01-05 | IN001 | A | Fictional client | Income | 500 | Checking | INV001 | Calculated in workbook |
On this page6
Import the supplied XLSX into your own Google Drive, then save it as Google Sheets. Check the worked example before entering real records. Review sharing, date locale, formulas and protected ranges after conversion. The pack contains no hosted Sheets link and does not connect to your account. Keep receipt documents private and record only their references in the shared sheet.
Create a private Google Sheets bookkeeping template
Start with the worked file if you want to check the import. In Sheets, use File and Import to select the local XLSX. Save the result as Google Sheets. Keep it restricted while you inspect it. A file in your Drive is not necessarily private if its folder already has broad access.
Check the imported record
Company A January should show 180, with Office at 100 and Travel at 80. The 999 February row stays outside January. These are fictional checks. Confirm that dates remain dates and that amount cells remain numeric. Check the SUMIFS ranges if a result differs.
Set sharing and protect formulas
Give edit access only to those entering or reviewing the records. Check inherited folder access and link-sharing settings. Protected ranges limit editing; they do not hide data from someone allowed to view the sheet. Keep private receipts in separate controlled storage.
FAQ: Sheets copies
Is there a hosted copy link?
This local pack supplies an XLSX that you import into your own account. It does not provide a pre-created Google Sheets file. After import, save the converted sheet and check its sharing settings. Keep the original worked file for comparison if formulas or date formats behave differently in your account.
Will a CSV retain the workbook?
A CSV export carries the selected tab's rows as plain data. It does not keep the multi-tab workbook, formulas, formatting or protection. Save the Google Sheets file as the working record and keep a separate workbook backup when needed. Inspect the CSV before importing it into any other system.
Does a protected range secure receipts?
No. It helps control editing inside the spreadsheet. It does not stop a viewer from reading visible data or copying it. Store receipt documents privately, limit their sharing separately and use a source ID in the register. Check the permissions of the receipt folder as well as the sheet.
How should I handle date locale?
Set the spreadsheet locale for your intended date and decimal conventions. Inspect dates that could mean different days under another locale. Use a clear display format and compare the underlying value to the source. Changing display format alone may not turn imported text into a usable spreadsheet date.
Sources and checks
Checked 15 October 2026. The examples are fictional and the arithmetic is original.
- IRS records: Business recordkeeping and supporting documents.
- Excel SUMIFS: Official multiple-criteria sum syntax.
- Sheets SUMIFS: Official Sheets multiple-criteria sum syntax.
- IRS books: Publication 583, December 2024 edition, Recordkeeping System section.
Related records and guides
Verdict on the Google Sheets bookkeeping template
Use a private Google Sheets bookkeeping template after checking the import and its access. Keep the source trail and the worked checks close to the live records.
Keep the worked file beside your records
Compare the fictional example with the blank fields before starting.