Bookkeeping
How to Clean Up Two Years of Messy Villa Books in Bali
A practical bookkeeping cleanup process for Bali villa owners with incomplete records, mixed accounts, missing invoices and unreconciled booking payouts.
By Bali Accounting editorial desk · Editorial updated 2026-10-23. General information, not a claim of licensed professional review.
Yes, two years of messy villa books can usually be brought under control, but the work should begin with evidence and reconciliation rather than guesswork. A proper bookkeeping cleanup in Bali separates business and personal transactions, reconstructs income and costs, matches bank and platform activity, records unresolved items, and creates a repeatable month-end process. It does not mean inventing missing documents or deciding tax treatment without the responsible adviser.
Who this applies to
This process is for villa owners, operators and management companies whose records have fallen behind or become unreliable. It is particularly useful where a villa has changed managers, used several booking channels, paid suppliers in cash, mixed owner spending with property expenses, or relied on bank statements instead of a maintained ledger.
It also applies when the books look complete but the reported numbers cannot be explained. A bank balance is not the same as profit. A booking-platform payout is not necessarily the same as the guest reservation value. An owner withdrawal may be recorded as an expense, while a supplier deposit may be missing from the month in which it was paid.
The cleanup scope should be agreed before work starts. Confirm the legal entity or operating arrangement, properties included, accounting period, currencies, bank accounts, e-wallets, booking channels, management accounts, payroll-related records, supplier files and owner transactions. If one entity operates several villas, decide whether the final records need property-level reporting as well as an entity-level view.
Owners with records connected to tax registration, company compliance, employment, licensing or other regulated matters should also identify the qualified adviser responsible for those questions. Bookkeeping can organize evidence and calculations, but it does not replace tax, legal or immigration advice.
What a responsible two-year cleanup looks like
A useful cleanup has five stages. The first is collection. Gather bank statements, platform statements, payment processor reports, cash logs, invoices, receipts, contracts, management statements, utility bills, payroll evidence and owner funding records. Request original files where possible rather than relying on screenshots or manually typed summaries.
The second stage is an opening-balance review. List every account that should exist, including bank, petty cash, platform receivables, supplier balances, owner funding and loans. Compare the earliest available statement with the opening figures in the existing books. If an opening balance cannot be supported, mark it as an opening difference for investigation instead of silently replacing it.
The third stage is transaction reconstruction. Import or enter activity into a consistent ledger, then apply dates, descriptions, accounts, property codes and evidence references. Keep the transaction date separate from the settlement date. For example, a guest stay may occur in one month, the platform may issue a statement in another, and the bank payout may arrive later.
The fourth stage is reconciliation. Reconcile each bank account to its statement, each booking channel to its statement and each material supplier or owner balance to available evidence. Investigate differences by category: timing, fee, refund, transfer, duplicate, missing document, exchange difference or unknown item.
The final stage is review and handover. Produce a list of unresolved questions, corrected reports, supporting schedules and a short control procedure for future months. A cleanup is not finished merely because every row has an account code. It is finished when the owner can understand what remains uncertain and another person can continue the process.
| Workpaper | Purpose | Minimum useful evidence |
|---|---|---|
| Bank reconciliation | Explains the difference between the ledger and statement balance | Full statement, ledger extract and outstanding-item list |
| Booking-channel reconciliation | Connects reservations, fees, refunds and payouts | Monthly platform statement and bank receipt |
| Supplier schedule | Tracks invoices, payments, deposits and missing documents | Invoice register, payment proof and supplier correspondence |
| Owner transaction schedule | Separates funding, withdrawals and personal spending | Bank evidence and owner explanation |
| Open-items register | Prevents unresolved issues from disappearing | Question, amount, period, owner and next action |
The detailed workflow
1. Freeze the source population
Set a cut-off date and preserve copies of the files received. Record which periods and accounts are covered. This avoids a moving target in which new spreadsheets overwrite earlier evidence. Name files consistently, for example by year, month, account and source, and retain the original export before making adjustments.
2. Build a transaction map
Before posting everything, map the money flows. A typical Bali villa may receive direct transfers, platform payouts and cash, while paying cleaners, maintenance providers, utilities, management fees, supplies and owners. The map should show where each flow starts, which account receives it, which fee or deduction intervenes, and where it is finally recorded.
Use separate labels for property, entity and owner. If a manager collects guest money and later transfers a net amount, the records should preserve the relationship between the guest activity, manager statement, fees and cash receipt. Do not use the net bank deposit as a substitute for the underlying activity when the supporting statement is available.
3. Reconcile in a sensible order
Start with bank accounts because they provide a dated external control total. Then reconcile payment processors and booking channels. After that, review suppliers, payroll-related records and owner balances. This order reduces the chance of treating a missing transfer as a missing sale or treating a platform deduction as a property expense without evidence.
For every difference, write a short explanation. “Timing difference: payout received next month” is more useful than “adjusted.” “Duplicate invoice found and removed” is better than “cleaned.” The explanation should refer to the relevant statement, invoice or correspondence.
4. Correct classifications carefully
Corrections should preserve the audit trail. Use a dated adjustment or reclassification with a clear description, source reference and reviewer note. If the correct treatment depends on a legal or tax interpretation, place the item in an adviser-review queue rather than making an unsupported conclusion.
Separate repairs from improvements where the available information allows, but do not force a distinction that the evidence cannot support. Similarly, do not convert every owner-paid item into a business cost. Record who paid, who benefited, whether the entity owes the person anything, and what document supports the entry.
5. Re-run reports and compare periods
Once the ledger is corrected, produce a period-by-period income and expense report, balance or account summary, bank reconciliation and open-items list. Compare unusual movements with bookings, occupancy records, major maintenance and owner transfers. The objective is not to create a perfect narrative; it is to identify explanations that are supported, unsupported or still pending.
Illustrative IDR worked example
The following is a bookkeeping example only, not a tax calculation. Assume one month has three booking receipts recorded from source documents: IDR 12,000,000, IDR 8,500,000 and IDR 6,000,000. The total guest activity is IDR 26,500,000 because IDR 12,000,000 + IDR 8,500,000 = IDR 20,500,000, and IDR 20,500,000 + IDR 6,000,000 = IDR 26,500,000.
The platform statement shows a booking-channel fee of IDR 2,120,000 and a refund of IDR 1,500,000. The bank receives IDR 22,880,000. The arithmetic is: IDR 26,500,000 - IDR 2,120,000 = IDR 24,380,000; IDR 24,380,000 - IDR 1,500,000 = IDR 22,880,000. The bank receipt therefore agrees with the platform activity, provided the refund relates to the same reporting population and no other adjustment exists.
If the old books recorded only the IDR 22,880,000 bank receipt as income, they understated the gross booking activity and concealed the fee and refund relationship. A cleanup workpaper would retain the platform statement, identify the three receipts, show the fee and refund separately, link the net payout to the bank line, and document any question about how the transaction should be presented for the entity’s reporting purpose.
A second simple check can concern owner funding. If the owner transfers IDR 15,000,000 into the business account and the business later pays IDR 9,000,000 to a contractor, the remaining funding balance in this narrow example is IDR 6,000,000 because IDR 15,000,000 - IDR 9,000,000 = IDR 6,000,000. That does not by itself determine whether the transfer is capital, a loan, reimbursement or income. The documents and responsible adviser determine the appropriate treatment.
What owners get wrong
- Correction one: treating the bank statement as the books. A bank statement proves movement through an account, not the business purpose, gross booking activity, unpaid supplier balance or owner relationship. Use it as a control source, then connect each material line to evidence and a classification.
- Correction two: posting net OTA payouts as sales. A net payout may hide platform fees, refunds, adjustments and timing differences. Obtain the channel statement and reconcile the components before deciding how the ledger should present them.
- Correction three: filling gaps with estimates without labeling them. An estimate may be useful for management planning, but it should not be presented as supported historical bookkeeping. Mark assumptions clearly, keep them in an open-items register and seek the relevant adviser’s direction where the distinction matters.
Another common mistake is starting with a preferred profit figure and forcing the records to match it. The better sequence is evidence, posting, reconciliation, review and explanation. Owners should also avoid deleting old files after a corrected ledger is produced. Preserve the original records and the reason for each material correction.
Printable cleanup checklist
Use this as a working checklist and add an owner, due date and evidence reference to each unresolved item.
- Scope: confirm periods, properties, entities, currencies and reporting purpose.
- Sources: collect bank statements, platform exports, processor reports, invoices, receipts, contracts and management statements.
- Access: confirm that every bank, wallet and booking-channel account has a complete export for the agreed period.
- Opening balances: list starting balances and identify any unsupported differences.
- Chart of accounts: agree consistent categories and property or department codes.
- Bank control: reconcile each statement period and list outstanding transfers, deposits and unknown lines.
- Booking control: match reservations or channel statements to fees, refunds, adjustments and payouts.
- Supplier control: match invoices to payments and flag missing, duplicate or disputed documents.
- Owner control: separate funding, withdrawals, reimbursements and personal transactions.
- Payroll-related evidence: retain approved records and refer regulated treatment questions to the responsible adviser.
- Corrections: document date, amount, reason, source and reviewer for each adjustment.
- Review: compare reports with booking calendars, major repairs and cash movements.
- Handover: deliver reconciliations, reports, open items and the next month’s close procedure.
- Prevention: set a monthly record-collection date and an owner for each missing document.
For a structured ongoing process, compare the cleanup output with the Bali villa bookkeeping checklist and the month-end record-collection workflow. If booking platforms are a major source of unexplained differences, the OTA payout reconciliation workflow provides a useful control model.
Bali Accounting can scope bookkeeping cleanup and ongoing record preparation through its villa accounting services. Preparation and any submission work require the responsible authorised person and a separate engagement; they are not automatic inclusions in a monthly bookkeeping arrangement. For a defined review of records, owners may use the Client Advisory intake.
General information disclaimer: This article is general bookkeeping information, not tax, legal, accounting-opinion, immigration or licensing advice. It does not state current rates, thresholds, deadlines, permissions or filing requirements. Actual treatment depends on the entity, documents, contracts and applicable rules. Ask the responsible licensed or authorised adviser before relying on a classification or submitting information.
Frequently asked questions
Can two years of villa books be cleaned up from bank statements alone?
Bank statements are an important starting control, but they are rarely sufficient. Platform statements, invoices, contracts, owner explanations and payment evidence may be needed to distinguish income, fees, refunds, transfers, funding and personal spending.
Should missing receipts be replaced with estimates?
Not silently. A clearly labelled estimate may support internal planning, but unsupported historical entries should remain identifiable in an open-items register and be reviewed by the responsible adviser where reporting treatment matters.
How should OTA payouts be handled during cleanup?
Match each payout to the platform statement, including booking activity, fees, refunds, adjustments and settlement timing. The net bank receipt should not automatically replace the underlying platform record.
What should an owner receive when the cleanup is complete?
The handover should normally include corrected reports, bank and platform reconciliations, supporting schedules, documented adjustments, an unresolved-items list and a practical monthly close procedure.
Does bookkeeping cleanup decide my tax position?
No. Cleanup organizes and explains records. Tax classification, filing positions and other regulated conclusions should be confirmed with the responsible qualified adviser under a separate engagement.
Related services and practical guides
Continue with Bali Airbnb Bookkeeping: Reconcile Airbnb and Booking.com Payouts.
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.
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 bookkeeping cleanup in Bali. Advice and project work require their own agreed scope; these articles are general information.
Related guides
- Bali Villa Bookkeeping Checklist: A Monthly Rental Property Close
- A Multi-Property Bookkeeping Workflow for Bali Villa Managers
- Property Management Bookkeeping: Separate Owner Liabilities from Company Revenue
Need help applying this process? Explore the relevant service scope, sample owner report and bookkeeping package inclusions.