Thoughtful templates. Instant downloads.
RizqtekStudio.
Launch gift: 4 of 5 free template claims remainUse STUDIOFIRST5 →

LedgerLift — Bank CSV Importer & Book Reconciler

EXCEL TEMPLATE · BUSINESS & WORK

LedgerLift — Bank CSV Importer & Book Reconciler — Excel Template

Import raw bank CSV exports, standardize dates/signs, auto-categorize by keyword & reconcile with Books.

Eliminate manual bank export cleanup. LedgerLift imports bank CSV files from Google Drive, standardizes DMY/MDY/ISO dates and signed or debit/credit amounts, applies priority-ordered keyword categorization rules, flags possible duplicates conservatively, and reconciles bank transactions against your Books register.

$69.00 USD · ONE-TIME PURCHASE

Digital download · No physical item

Refunds & download support · Template licence

Software requirementsGoogle Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

Try the free budget starter · Read practical guides

  • Imports bank CSV exports (up to 5,000 rows / 2 MB per file) with configurable delimiter, date order, and signed or debit/credit columns
  • Priority-ordered case-insensitive keyword Rules with direction filtering (IN, OUT, ANY)
  • Conservative duplicate guard: skips exact repeat IDs/files and flags overlapping no-ID transactions as POSSIBLE DUPLICATE

From the people who use it.

No published customer reviews yet.

Purchased this product? Sign in to review it. Link guest orders from your private receipt first.

Consider the details.

What’s inside
  • Imports bank CSV exports (up to 5,000 rows / 2 MB per file) with configurable delimiter, date order, and signed or debit/credit columns
  • Priority-ordered case-insensitive keyword Rules with direction filtering (IN, OUT, ANY)
  • Conservative duplicate guard: skips exact repeat IDs/files and flags overlapping no-ID transactions as POSSIBLE DUPLICATE
  • Automated Books reconciliation linking uniquely matching entries by shared reference, signed amount, account, currency, and date window
  • Includes complete Google Apps Script (03-LedgerLift.gs), comprehensive guide, and bank/books/rules sample CSVs

03-LedgerLift.gs, 03-LedgerLift-GUIDE.md, START-HERE.md, SELLER-ACCEPTANCE.md, and examples/bank-sample.csv, examples/books-sample.csv, examples/rules-sample.csv packaged in a clean ZIP archive.

Software & capacity

Google Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

  • Requires Google Sheets and Google Drive permissions to read uploaded bank CSV exports.
  • Supports two-decimal currencies and up to 5,000 rows per import; three-decimal currencies are outside this edition.
  • Reconciliation links unique reference + amount matches within MatchWindowDays; ambiguous rows remain flagged for manual review.
Download & getting started
After captured payment is verified, the order page provides your download links. Save your private order access link. Extract the ZIP, read Quick_Start.txt, and save a working copy of the clean workbook. Read the download guide
Licence & product support
One purchaser may use this digital automation package internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the source files or scripts is prohibited. Copyright 2026 RizqtekStudio. All rights reserved. Read the licence

Questions about this template

What is included with LedgerLift — Bank CSV Importer & Book Reconciler?

03-LedgerLift.gs, 03-LedgerLift-GUIDE.md, START-HERE.md, SELLER-ACCEPTANCE.md, and examples/bank-sample.csv, examples/books-sample.csv, examples/rules-sample.csv packaged in a clean ZIP archive.

What software is required to use LedgerLift — Bank CSV Importer & Book Reconciler?

Google Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

How do I receive LedgerLift — Bank CSV Importer & Book Reconciler after purchasing?

After captured payment is verified, your private order page provides download links and a receipt is emailed. A valid complimentary claim also provides access without payment.

What licence applies to this template?

One purchaser may use this digital automation package internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the source files or scripts is prohibited. Copyright 2026 RizqtekStudio. All rights reserved.

A little more possibility.

All templates