Getting started4 min read
Import opening balances from Excel
Opening balances let you start using BukuCloud mid-year without losing history. The Import wizard walks you through it.
01Pick a cut-over date
Choose a clean cut-over (most SMEs pick the start of a month or financial year).
Pull a Trial Balance from your old system as of one day before the cut-over.
Pull an Aged Receivables and Aged Payables list as of the same date.
02Run the import
- 1Open Settings → Data → Opening balances.
- 2Upload the Trial Balance into Step 1 (account code + balance).
- 3Upload Aged Receivables in Step 2 (customer + invoice + amount + due date).
- 4Upload Aged Payables in Step 3 (supplier + bill + amount + due date).
- 5Review the journal preview. Click Post.
03What it creates
A single dated opening-balance journal so reports run cleanly from day one.
Per-customer and per-supplier ledgers carrying their open balances.
An import audit log entry with the original file attached.
Heads up
If the trial balance does not balance to zero, the wizard will block posting until you fix the source. Borrow a tea, take your time.