SEO
Bookkeeping Software Migration: Preserve Opening Cutover Evidence
A practical guide for Bali villa owners moving bookkeeping systems without losing the evidence behind opening balances, owner funding, platform payouts and reconciled cash.
By Bali Accounting editorial desk · Editorial updated 2026-10-30. General information, not a claim of licensed professional review.
During a bookkeeping software migration, preserve the old reports, transaction exports, bank statements, platform payout schedules, invoices and reconciliation files before importing anything. Then agree a dated cutover, compare selected totals between systems, and document every opening balance with its supporting evidence. The objective is not merely to move data; it is to show how the new books began and which items remain unresolved.
Who this applies to
This guide is for Bali villa owners, operators, property managers and finance teams changing from spreadsheets or one accounting platform to another. It is especially relevant where a villa receives booking-platform payouts, uses more than one bank account, handles multiple currencies, records owner funding or shares costs between properties.
It also applies when a PT PMA changes bookkeepers, adopts a new chart of accounts or asks a new accounting team to take responsibility from a particular month. A migration can be technically successful while still leaving weak evidence. A clean-looking new dashboard does not prove that the opening figures are complete, correctly classified or supported.
The responsible owner should decide which records must be retained and which questions need a licensed tax or legal adviser. Bookkeeping support can organise evidence and identify exceptions, but it does not determine tax treatment, legal ownership, company obligations or filing positions.
Why the cutover date matters
The cutover date is the boundary between the old bookkeeping environment and the new one. It should be written down as a specific date and linked to a defined reporting period. Without that boundary, the team may import transactions twice, omit late supplier invoices or treat an old closing figure as if it were independently verified.
For a villa, the cutover is rarely just a bank balance. It may include unpaid supplier invoices, guest deposits, platform amounts not yet paid out, staff advances, owner contributions, refundable amounts, foreign-currency accounts and transactions paid personally by an owner. Each item needs a description, amount, currency, date, source and status.
Before migration, freeze or archive the old system in a readable form. Save the general ledger export, account list, customer and supplier lists, bank reconciliations, management reports, invoice attachments and audit or activity logs where available. Keep a copy that is not silently overwritten by later edits. If the old platform can export reports as PDF and data as CSV, retain both: the PDF shows how the report appeared, while the data file permits detailed checking.
Do not assume that an import is a complete historical archive. Attachments may not transfer, deleted transactions may be excluded, tracking categories may map differently, and dates or currencies may be converted. Record the migration method, software versions if relevant, export dates and the person who approved the cutover.
Build an evidence pack before importing
A useful evidence pack lets another reviewer understand the opening position without relying on memory or access to the retired software. Use a folder structure that separates source records from working schedules and final approvals. A simple index can identify the period, account, file name, source and review status.
- System records: closing reports, account lists, transaction exports, customer and supplier balances, and retained attachments.
- Cash evidence: statements for each bank and cash account, reconciliations, outstanding transfers and explanations for unreconciled items.
- Booking evidence: platform reservation reports, payout statements, refunds, cancellations, commissions, reserves and the related bank receipts.
- Supplier evidence: invoices, payment approvals, credit notes, contracts where relevant and a list of invoices received after the planned cutover.
- Owner and company evidence: funding schedules, withdrawal records, reimbursement claims and documents showing whether a movement was made for the business or personally.
- Migration controls: the cutover memo, mapping between old and new accounts, exception register, approval notes and post-import comparison.
Keep original files unchanged. If a document needs a clearer name or translation note, create a working copy and retain the original. Avoid replacing a bank statement with a spreadsheet that merely repeats its ending balance. The statement is evidence; the spreadsheet is a schedule derived from that evidence.
For platform income, retain both the booking-level report and payout report where available. A payout can combine several stays, deduct fees or include a reserve. Recording only the bank deposit can hide the relationship between guest activity, platform deductions and cash received. The same principle applies to payment processors and management-company statements.
For related practical controls, see how to resolve unmatched villa bank transactions and how to reconcile Airbnb and Booking.com payouts. These are record-keeping guides, not instructions to adopt a particular tax treatment.
Map the old records to the new system
Prepare a mapping schedule before the import. It should show each old account, the proposed new account, the reason for the mapping and any question requiring owner approval. Do not force unlike items into a convenient category simply because the new software requires a destination.
| Old record or balance | New destination | Evidence to retain | Review question |
|---|---|---|---|
| Villa operating bank | Operating bank account | Cutover statement and reconciliation | Does the statement ending balance agree? |
| Owner-paid utility invoice | Expense plus owner funding or payable review | Invoice and payment proof | Who paid, and was the company obligated? |
| Platform payout pending | Platform receivable or clearing schedule | Payout report and subsequent receipt | Was it already included in bank cash? |
| Guest security amount | Separate refundable-balance review | Booking record and receipt | Is it still held or already returned? |
| Foreign-currency wallet | Distinct currency account | Statement and exchange record | Which currency and date were used? |
Account names are not enough. Document the meaning of each important category and the property or owner to which it relates. If the old system grouped cleaning, repairs and supplies together, do not imply that the historical split is known unless the underlying invoices support it. A transparent “historical classification requires review” note is stronger than an unsupported precision.
Illustrative IDR cutover example
The following is an illustrative cash-movement schedule, not a trial balance, tax calculation or complete set of accounting entries. Assume a villa’s approved cutover date is 30 June. The bank statement shows IDR 48,000,000. A separate cash count shows IDR 2,500,000. An owner-funded supplier payment of IDR 3,200,000 was documented but had not passed through the business bank. A platform payout of IDR 6,000,000 was included in the booking report and arrived in the bank on 2 July, so it is not included in the 30 June bank figure.
| Selected movement or evidence | Amount | Cutover treatment for review |
|---|---|---|
| Operating bank statement at 30 June | IDR 48,000,000 | Compare to the imported bank balance |
| Physical cash count at 30 June | IDR 2,500,000 | Retain count sheet and responsible-person sign-off |
| Owner-paid supplier invoice | IDR 3,200,000 | Keep outside bank cash and review as owner funding or payable |
| Platform payout received on 2 July | IDR 6,000,000 | Keep in post-cutover receipt evidence, not 30 June bank cash |
The selected cash resources evidenced at 30 June are IDR 48,000,000 plus IDR 2,500,000, which equals IDR 50,500,000. The owner-paid invoice is not added to that cash total because no business cash was received. It is a separate documented obligation or funding question. The IDR 6,000,000 payout is also not added because it arrived after the cutover date. This simple separation prevents a post-cutover receipt from being mistaken for opening cash.
In practice, the full opening review would also consider unpaid bills, guest deposits, platform receivables, owner withdrawals, foreign-currency balances and other supported items. Do not present the four lines above as a complete balance list. The point is to show how dated evidence and explicit cash movements can prevent double counting.
What owners get wrong
1. Treating the imported report as proof. An import confirmation only shows that data was accepted. It does not show that every attachment, reconciliation, currency or tracking detail transferred. Correction: compare selected old and new reports, retain the export, and investigate differences rather than accepting an automated success message.
2. Using the bank balance as the whole opening position. Bank cash cannot explain a supplier invoice paid by an owner, a platform receivable, a refundable guest amount or a transfer still in transit. Correction: create separate evidence schedules for cash, receivables, payables, owner movements and refundable amounts.
3. Backdating unresolved decisions. A team may guess whether a payment was a company expense, owner withdrawal or capital movement so the new system balances neatly. Correction: record the uncertainty in an exception register, request documents, and refer classification or tax questions to the responsible qualified adviser.
A practical cutover workflow
- Define scope. List entities, properties, currencies, bank accounts, platforms, suppliers and the exact cutover date.
- Archive the old system. Export reports, detailed transactions, attachments and reconciliations before changing the chart or closing periods.
- Collect independent evidence. Obtain bank statements, cash counts, payout reports, invoices and owner-funding documents for the relevant period.
- Prepare mappings. Match old accounts and tracking fields to the proposed new structure, marking uncertain items for review.
- Reconcile selected controls. Compare bank ending figures, platform receipts, supplier totals and owner schedules using dated source documents.
- Import with a controlled method. Record what was imported, what was entered manually and what remains in a separate schedule.
- Review the opening reports. Check dates, currencies, property tags, duplicate transactions, attachments and unusual balances.
- Approve or qualify. Sign off supported opening items and list unresolved exceptions with an owner, next action and target review period.
The onboarding period should be an adaptable planning example, not a guaranteed turnaround time. A simple single-property migration with complete exports may need a different sequence from a multi-property operation with several currencies and missing records. Agree the scope and review points in writing rather than promising a fixed completion date before the evidence is inspected.
Bali Accounting can discuss a separately scoped cleanup and migration project through its villa bookkeeping cleanup service. For an agreed engagement, a Client Advisory conversation can establish what records are available, what the new system needs and which questions must be handed to the responsible tax or legal professional. Preparation and any submission work are not automatic inclusions in monthly bookkeeping.
Printable migration checklist
Print or copy this list into the migration file. Mark each item complete only when the supporting file is present and its period is clear.
- Scope: entity, property, currencies, platforms, bank accounts and cutover date recorded.
- Archive: old reports, transaction exports, account list, attachments and reconciliations saved in read-only form.
- Bank: each cutover statement obtained; outstanding transfers and unmatched items listed.
- Cash: physical count dated and attributed to the person who performed it.
- Platforms: booking, payout, refund, commission and reserve schedules matched to receipts where possible.
- Suppliers: unpaid invoices, late invoices and credit notes listed separately from paid expenses.
- Owner movements: contributions, withdrawals, reimbursements and owner-paid bills supported by a schedule.
- Mapping: old-to-new accounts, property tags and currency treatment documented.
- Exceptions: missing documents, duplicate risks and classification questions assigned for follow-up.
- Comparison: selected old and new reports reviewed, with differences explained.
- Approval: the cutover memo states what is supported, what is provisional and who approved the next step.
Keep this checklist with the evidence pack, not only in an email thread. Future bookkeepers should be able to see why the opening figures were used, which records were unavailable and what must be revisited. For wider monthly controls, compare it with the Bali villa monthly bookkeeping checklist and the guidance on preparing villa records for an Indonesian tax consultant.
This article is general information for record-keeping and bookkeeping planning. It is not tax, legal, accounting or immigration advice for a particular person or entity, and it is not evidence of professional review. Tax treatment, company obligations, reporting positions and any submission should be confirmed with the responsible authorised person under a separate engagement.
Frequently asked questions
Should every historical transaction be migrated?
Not necessarily. The appropriate history depends on reporting needs, evidence quality, software limits and the agreed scope. Retain an accessible archive even where only a defined period is imported. Document the cutover and explain any opening figures brought forward from older records.
What is the most important file to save before migration?
There is no single universal file. Save a complete archive that includes detailed exports, closing reports, bank statements, reconciliations, attachments and platform schedules. A report without its underlying evidence may not explain how a balance was produced.
Can software automatically preserve owner funding?
Software can import transactions, but it cannot reliably determine whether a movement was owner funding, a reimbursement, a withdrawal, a loan or something else without supporting facts. Keep the payment proof, explanation and relevant company records, then obtain qualified advice where classification matters.
How should a missing opening document be handled?
List it in an exception register with the date, amount, counterparty, account and requested replacement evidence. Do not silently invent a description or backdate a document. A provisional record should remain clearly identified until the responsible reviewer decides how it should be treated.
Does migration preparation include tax filing?
No. Preparing and organising bookkeeping evidence is different from determining tax treatment or submitting a return. Filing, tax advice and related compliance work require a separately agreed scope and the responsible authorised person. Discuss the evidence pack with a licensed Konsultan Pajak when tax questions arise.
Related services and practical guides
Continue with Bookkeeping Cleanup: Building an Evidence-Based Opening Balance. Continue with Preparing Records for a Bali Tax Consultant: The Evidence Pack.
Scope: This article is general information, not tax advice, legal advice or immigration advice. Illustrative figures are not client results. Requirements and rates may change; ask a licensed Indonesian Konsultan Pajak or the appropriate qualified adviser about your actual circumstances. Editorial quality checks are not a licensed professional review.
For ongoing support, explore our Bali accounting and villa bookkeeping services. Project work and monthly bookkeeping have separately agreed scopes.
AI-generated editorial illustration, not an actual client property, official document or photograph of a reported event.
Related services and next steps
For ongoing records, explore our Bali accounting and villa bookkeeping services. For this topic, see accounting services in Bali. Advice and project work require their own agreed scope; these articles are general information.
Related guides
- Monthly Bookkeeping Cost: Compare Villa Deliverables Before Fees
- Month-End Bookkeeping: Handling Late Supplier Invoices
- Villa Petty Cash Reconciliation: Vouchers, Floats and Counts
Need help applying this process? Explore the relevant service scope, sample owner report and bookkeeping package inclusions.