How to set up and process automatic prepayments and accruals
Description

In Sage 50 Accounts, you set up prepayments and accruals to post automatically as part of your month end routine.

NOTE: The automatic Prepayment and Accrual 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 accruals and prepayments using journals.

Cause
Resolution

Prepayments

Set up a prepayment

 EXAMPLE: Create a payment to correct a rent payment of £/€600.00 covering a three-month period. For example, you pay rent in January which covers January, February and 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've the charities option enabled.
    Prepayment N/C Updated automatically.
    Value The total net value of the prepayment, for example, 600.00.

    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 prepayment check box.  


Automatic prepayment postings

 EXAMPLE: Prepay £/€600.00 for rent every three months and account for the cost over that period. Process the rent invoice or payment as usual as a purchase invoice or a bank payment to the rent nominal code. After creating the prepayment, the following transactions post during the month end routine. 

Month one

Transaction N/C Nominal Name Debit Credit
Prepayment Reverse 1103 Prepayments 600.00  
Prepayment Reverse 7100 Rent   600.00
Prepayment 1 7100 Rent 200.00  
Prepayment 1 1103 Prepayments   200.00

In month one, the reverse prepayment immediately cancels the effect of the original payment or invoice. The monthly value posts back to the rent nominal code, adjusting the rent account to £/€200.00 per month instead of £/€600.00.

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 the prepayment nominal code is zero. This is because the three monthly instalments reverse the original posting from month one.

TIP: If you can't evenly divide your prepayment amount by the number of months, the software rounds in the final month.


Accruals

Set up an accrual

 EXAMPLE: We're creating an accrual for a telephone bill that we receive every three months. We've estimated the charge to be £/€300.00. 

  1. Go to Nominal codes, then click Accruals.
  2. Enter the relevant information to record the Accrual in the Accruals window, for example:

    TIP: If preferred, you can click Wizard then follow the on-screen prompt.

    N/C Nominal code, for example, Electricity
    Details Description, for example, Accrual
    Department Enter a department, if required
    Fund Enter a fund, if required. Only available if you've the charities option enabled
    Accrual N/C Updated automatically
    Value Total net accrual value, for example, 300.00

     TIP: If the monthly values change during the length of the accrual, delete and re-add the accrual.
    Months Number of months for the accrual. This can be between 2 and 12
    Monthly Amount Updated automatically
    Posted Updated automatically
  3. Click Save, then OK.

You've now created an accrual. The software will process this when you next run your month end routine by selecting the accrual check box.  


Automatic accrual postings

 EXAMPLE: Create an accrual to accrue £/€100.00 a month for electricity, to account for the cost for over a three-month period. The accrual postings then reverse in the final period.

Month one

Transaction N/C Nominal Name Debit Credit
Accrual 1 7200 Electricity 100.00  
Accrual 1 2109 Accruals   100.00

The software posts the monthly value to your expense nominal code each month, and the opposite entry posts to your accruals nominal code.

NOTE: The Accruals nominal code is a current liability on the balance sheet, showing the value of services used but not yet paid for.

Month two

Transaction N/C Nominal Name Debit Credit
Accrual 2 7200 Electricity 100.00  
Accrual 2 2109 Accruals   100.00

Month three

Transaction N/C Nominal Name Debit Credit
Accrual 3 7200 Electricity 100.00  
Accrual 3 2109 Accruals   100.00
Accrual Reverse 2109 Accruals 300.00  
Accrual Reverse 7200 Electricity   300.00

Reverse the total value of the monthly postings in the final month, reducing the balance on the accruals and expense nominal codes to zero.

The monthly balance on the expense nominal code for the final month is a credit balance. In the above example, after the final accrual posting the month three balance on the Electricity account is a £/€200.00 credit balance. If you run a report to show the monthly values, a liability shows in months one and two.

When you post the actual invoice or payment, the balance changes to a debit which represents one month's value. For example, a £/€315.00 electricity bill is £/€15.00 higher than you've accrued for, so month three £/€115.00.

TIP: If you can't evenly divide your prepayment amount by the number of months, the software rounds in the final month.

Any discrepancies appear in the final month as you don't know how much the invoice will be in advance so you make an estimate. If this happens, leave the discrepancy in the final month.


If you miss a month

Always run your month end routine in month order. If you've missed a month and run the next month end, it isn't possible to go back and run it again.

If you've just run the month end routine, restore a pre-month end backup. You can then - the month end option for last month, then run it for this month. You'll need to enter any transactions posted since you took the backup again.

What to do if you can't restore a backup

If you're unable to restore a backup, delete all prepayments and accruals. You can then continue to post them manually for the remaining period of the prepayment or accrual.

If you need to delete a prepayment or accrual from the list, use function key F8.
[BCB:366:UKI - training sales:ECB]

 

Steps to duplicate
Related Solutions