How to set up and process automatic prepayments
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.

Cause
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.

  1. Go to Nominal codes, then Prepayments.
  2. 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.
  3. 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.

 


If you miss a month

Follow our Correct month end postings if you miss a month article.

[BCB:366:UKI - training sales:ECB]

 

Steps to duplicate
Related Solutions