import-my-prior-books

Import prior-period bookkeeping exports to seed chart of accounts and trial balance.

2|Updated May 8, 2026
One-click install
npx skills add https://github.com/akiotanaka847/qaio-desktop --skill import-my-prior-books
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: import-my-prior-books
Source: https://github.com/akiotanaka847/qaio-desktop/tree/main/store/agents/bookkeeping/.agents/skills/import-my-prior-books
Command: npx skills add https://github.com/akiotanaka847/qaio-desktop --skill import-my-prior-books

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It prevents your bookkeeping workflow from starting “from scratch” by importing prior-period books so the system already knows your chart of accounts and vendor categorization history.

Core Features & Use Cases

  • Backfills prior books from real exports: Ingests QuickBooks Online or Xero exports, or a generic CSV/xlsx/spreadsheet from a prior accountant.
  • Seeds your starting financials: Seeds your chart of accounts (only if missing) and builds an opening trial balance from prior closing balances for the correct fiscal year boundary.
  • Learns vendor-to-account rules safely: Infers vendor-to-account codes from transaction history using a strict ≥80% majority threshold (with minimum data checks) to avoid noisy parties poisoning future categorization.
  • Read-only import guardrail: Uses one-way historical reads only; it never connects back to QuickBooks Online/Xero to push changes or rewrite prior books.

Quick Start

Drop your prior-year QuickBooks Online or Xero export file (xlsx or csv), then confirm your fiscal year end and whether your books are cash or accrual.

Frequently Asked Questions about import-my-prior-books

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I import prior bookkeeping history from a CSV file into a new accounting period?

You can import prior bookkeeping history from CSV or xlsx files to seed your chart of accounts, build an opening trial balance, and establish vendor-to-account categorization rules for a new period.

Can I import QuickBooks Online or Xero exports to backfill my chart of accounts?

Yes, this skill ingests QuickBooks Online and Xero exports to seed your chart of accounts only if missing, and constructs an opening trial balance from prior closing balances at your fiscal year boundary.

How does vendor categorization learning work when importing prior period transactions?

Vendor categorization learning infers vendor-to-account codes from historical transactions using a strict ≥80% majority threshold with minimum data checks, preventing noisy parties from poisoning future categorization.

Does importing prior books connect back to QuickBooks Online or Xero to modify original records?

No, this skill uses one-way historical reads only and never connects back to QuickBooks Online or Xero to push changes or rewrite prior books, ensuring your source data remains untouched.

What file formats can I use to backfill bookkeeping history from a prior accountant?

You can backfill bookkeeping history using generic CSV or xlsx spreadsheet files exported from a prior accountant, as well as native QuickBooks Online and Xero export formats.

What information do I need to confirm before importing an opening trial balance?

Before importing an opening trial balance, you must confirm your fiscal year end date and whether your books are tracked on a cash or accrual basis to ensure correct seeding.