Switch from a spreadsheet
Outgrown the spreadsheet? Bring it with you.
Pick a start date, usually the first day of a month or year. Copy what you have into these templates (or save your own sheet as CSV with the same column names), then import each one in Settings → Import. Each step shows a preview first, and running a step twice never creates duplicates.
Templates, in the order to import them
- 1Download
Customers
One row per customer. Only the name is needed; the rest fills in their record.
Columns: Name, Email, Phone, Street, City, State, ZIP, Payment terms
- 2Download
Suppliers
One row per supplier. Put Yes under 1099 for contractors you'll send a 1099.
Columns: Name, Email, Phone, Street, City, State, ZIP, Payment terms, 1099
- 3Download
Products and services
What you sell, with its price. For a service, leave Cost, Quantity on hand and Track inventory blank.
Columns: Name, SKU, Description, Price, Type, Cost, Quantity on hand, Track inventory
- 4Download
Opening balances
Your trial balance on the day you start: each account with its debit or credit. Debits and credits must add up to the same total.
Columns: Account, Debit, Credit
- 5Download
Unpaid invoices
Invoices customers still owe on the day you start, with what's left to pay.
Columns: Customer, Invoice number, Invoice date, Due date, Open balance
- 6Download
Unpaid bills
Bills you still owe on the day you start, with what's left to pay.
Columns: Supplier, Bill number, Bill date, Due date, Open balance
Dates as 2026-10-15 or 10/15/2026; amounts without the $ sign. Bank transactions come in from your bank's own download (OFX, QFX or CSV) or a bank feed, from your start date on. Client trust balances are set up in Banking → Trust accounts, not in opening balances.
Not sure what your opening balances are?
Start with what's in the bank on your start date and what customers and suppliers owe. Your accountant can fill in the rest later, from a practice account if you invite them. Find an accountant.
Keep your spreadsheet
Nothing changes in your file. Keep it for the history before your start date; AccLyf Books takes it from there.
Your books, ready every day. From $19 a month.
Plans start at launch on January 1, 2027. Free until then, and Early Access testers get their first 2 months free plus Plus at $19 a month for 12 months. Bring your whole team; people are unlimited.