Sales data lives in three places
One Excel file for inventory, another for bookings, a register for receipts — and none of them agree at month end.
One live inventory: every booking, transfer and cancellation updates unit status, the customer ledger and the accounts at the same moment.