Summary
Description
In Sage 50 Accounts, you set up prepayments to post automatically as part of your month end routine.
NOTE: The automatic Prepayment feature isn't available in Sage 50 Accounts Essentials and Sage 50 Accounts Standard. To upgrade your software, leave your details, and we'll be in touch.
Alternatively you can post manual prepayments using journals.
Resolution
Before you start
Process the invoice or payment as usual as a purchase invoice or a bank payment to the overheads nominal code.
Set up a prepayment
In this example, we create a prepayment to show a rent payment of £/€600 covering a three-month period from January to March.
- Go to Nominal codes, then Prepayments.
- Enter the relevant information to record the prepayment in the Prepayments window, for example:
TIP: If preferred, you can click Wizard then follow the on-screen prompt.N/C Nominal code, for example, Rent. Details Details, for example Rent. Department Enter a department, if required, 0 by default. Fund Enter a fund, if required. Only available if you have the charities option enabled. Prepayment N/C Updated automatically. Value The total net value of the prepayment, for example, £/€600. If you can't evenly divide your prepayment amount by the number of months, the software rounds in the final month.
TIP: If the monthly values change during the length of the prepayment, delete and re-add the prepayment.Months Number of months for the prepayment. This can be between 2 and 12. Monthly Amount Updated automatically. Posted Updated automatically. - Click Save, then OK.
You've now created the prepayment. The software will process this when you next run your month end routine by selecting the Include any prepayments in the month end checkbox.
Automatic prepayment postings
After creating the prepayment, the following transactions post during the month end routine.
This example uses a prepayment of £/€600 for rent over three months.
In month one, the first posting cancels the effect of the original bank payment or purchase invoice on your overheads nominal code. The second journal posts month one value back to the overheads nominal code. This shows £/€200 on this nominal code instead of £/€600.
Month one
| Transaction | N/C | Nominal Name | Debit | Credit |
|---|---|---|---|---|
| Prepayment Value | 1103 | Prepayments | 600 | |
| Prepayment Value | 7100 | Rent | 600 | |
| Prepayment 1 | 7100 | Rent | 200 | |
| Prepayment 1 | 1103 | Prepayments | 200 |
Month two
| Transaction | N/C | Nominal Name | Debit | Credit |
|---|---|---|---|---|
| Prepayment 2 | 7100 | Rent | 200.00 | |
| Prepayment 2 | 1103 | Prepayments | 200.00 |
Month three
| Transaction | N/C | Nominal Name | Debit | Credit |
|---|---|---|---|---|
| Prepayment 3 | 7100 | Rent | 200.00 | |
| Prepayment 3 | 1103 | Prepayments | 200.00 |
At the end of the final month, the net effect on your Prepayments nominal code is zero. This is because the three monthly instalments reverse the original posting made in month one.
Bespoke training is available
Leave your details and we'll be in touch.
