Accruals, Prepayments and Deferred Income Schedule with Month-End Journals

Month-end adjustments for insurance, rent, licences, annual contracts billed in advance and audit fees are usually done in a spreadsheet rebuilt every month, with rounding that never quite adds up. This app takes each item once with the period it covers and keeps the schedule.

What is inside

• Four item types: prepayment, deferred income, accrued expense and accrued income, each with the amount excluding VAT, the period it covers and, where it applies, the payment or settlement date.
• Two spreading methods: actual days or equal calendar months, set as a default and overridable per item.
• The balance sheet balance at your balance date, the amount recognised in the month, and month-end journals that balance.
• A full month-by-month schedule for every item, exported as CSV, with CSV import for a list of items.
• Rounding carried in the running total, so the months always add up to the amount.
• A printable A4 journal page, example data, JSON backup and a README with a worked example in numbers.

What is fact and what is a setting This is arithmetic and states no UAE rule. How VAT is treated on an advance invoice or prepayment, which spreading method fits an item, your materiality limit and whether to book an accrual are your accounting policy and your accountant's call.

What it is NOT It does not model usage-based or milestone patterns, part payments or price changes, and it does not post to an accounting system. It is not accounting or tax advice.

How it was checked Balances, monthly amounts and journal totals were compared with an independent Python Decimal calculation over 40 random sets of items, with no difference. Typed screens, CSV, exports, reload, print view and phone width were tested in Chromium. Not tested in Safari, Firefox or Edge. Single business use.