To set up Prepayments, see How to automate expense recognition journals in ScaleXP .
To get to the Prepaid Expenses section, go to Journals (top tab), then EXPENSE RECOGNITION towards the bottom of the page.
How to write prepayment journals in ScaleXP
Once prepayments have been set up, go to Journals (top menu)> Journal: Prepayments (left sidebar) to see the financial impact on your accounts and post your journal.
The prepaid expenses journal page, which is downloadable, consists of the following:
- Section 1: Suggested Journal for each selected month, by account. This is calculated as Section 3 (recognised prepaid expenses) less Section 2 (bills invoiced directly to the expense account) less Section 4 (journals already made to the prepayments account). See details below.
- Section 2: Prepaid Bills as Allocated by ScaleXP. Once all bills have been allocated, this should only show balances on the income statement, not the balance sheet. All amounts allocated to dates after the report end date will be summed up and shown as prepayments in the final column of this section.
- Section 3: Bills as Coded (in accounting system) – a summary of bills identified as prepayments, shown in the month and account as originally coded in your accounting system
- Section 4: Existing Prepayment Journals (in accounting system)
- Section 5: Prepaid Bills by Supplier – this shows bills as allocated by ScaleXP, similar to Section 2 but organised by supplier rather than account code.
Section 1: Suggested Journal
The suggested journal is provided in Section 1: Suggested Journal.
This section looks only at costs identified as ending in a month after the bill issue date. See How to automate expense recognition journals in ScaleXP for how to identify these costs.
It summarises the amount the system believes needs to be journaled to the P&L and the Balance sheet based on:
- Bills and time periods identified as recognised in the month or later and
- Existing journals already in your accounting system.
Where ScaleXP suggests posting a journal, use the "Post draft journal" button to write the journal directly to your accounting system.
Section 2: Prepaid Bills as Allocated by ScaleXP
This section lists, by expense account and cost recognition date, all the invoiced bill line items identified as prepayments. These are allocated across the designated accounts and time periods as per the All Expenses and Review Prepayments reports.
Where invoiced bills have initially been coded to a balance sheet prepayments account in your accounting system, use Review Prepayments to identify which P&L account the cost should impact when expensed.
Total amounts to be expensed at dates after the end date of the report show in the Prepayments (Balance Sheet) column at the right side of Section 2.
Section 3: Bills as Coded (in your accounting system)
This section lists all bill line items identified as prepayments which have an issue date in the selected months and have been coded directly to an expense account.
These are used in conjunction with sections 2, 4 and 5 for the calculation of the recommended journal in Section 1.
Section 4: Adjustment for backdated cost
This section lists all bill line items which have a start date before the issue date and end date after the issue date. This is to adjust the prepaid expense journal for the line item element which is backdated at the issue date. (This element is also picked up separately in the accrued cost journal.)
Section 5: Existing Prepayment Journals (in your accounting system)
This section lists all existing journals in your accounting system which impact your selected prepayment accounts.
Only the side of the journal which impacts the expense account is shown in this section.
These existing journals are used in the calculation of the recommended journal in Section 1.
Section 6: Prepaid Bills by Supplier
Similar to Section 2, this shows all prepaid expenses as allocated by ScaleXP; in this case, the expenses are organised by supplier rather than by allocated expense account.
Accounting system Prepayments Balance
To quickly view the amount in Prepayments in your accounting system in order to compare it to the recommended amount in Section 2, see the note at the bottom of the page.
