Summary
Description
If you use the month end option to post depreciation, prepayments or accruals, you must run it for each month in order. If you miss a month, you can't go back and run it for the missing month.
If you've just completed your month end and realise you've missed a month, you should restore a pre month end backup. You can then run month end for last month and then this month. You must re-enter any transactions posted since you took the backup. For more information about restoring a backup
If you can't restore a backup, you must manually correct the postings.
Resolution
Correct fixed asset depreciation
To correct fixed asset depreciation, you must reverse all depreciation postings for each affected asset. Then delete the asset record, recreate it and post the depreciation postings again.
To reverse the depreciation journals posted for an asset
- Click Fixed Assets then double-click the asset.
- Click the Posting tab and note the nominal codes in Balance Sheet Depreciation N/C and P&L Depreciation N/C, click Save then Close.
- Click Nominal codes and select the two nominal codes you noted in step 2.
- Click Reports then Nominal activity.
- Select the Nominal Activity report then click Print then OK.
- Click OK on Criteria Values, check your printer settings then click OK.
- From the report, identify the transaction numbers of the journals you need to reverse.
TIP: The Details column on the report shows the description of the fixed asset.
- Back up your data.
- Click Nominal codes then Journal reversal and click OK.
- Enter the date for the first depreciation journals you want to reverse then in the Reference field enter DEPREC, then click OK.
- Select the journals you want to reverse then click Reverse then Save.
- Repeat steps 6 and 7 for each monthly depreciation journal you want to reverse.
If you have more than one asset, you should repeat the above steps for each affected asset.
To delete and recreate the asset
TIP: You can use the Duplicate option to generate a new record before deleting the original. However you must enter a new record reference, the cost price and book value.
- Click Fixed assets and select the relevant asset record then click Edit.
- Note the information in the Details and Posting tabs then click Close.
- Select the record then click Delete then Yes.
- Select New then enter the asset details you noted, ensuring that you enter the correct original cost price for the book value.
- Click Save then Close.
To post the correct depreciation
- Back up your data.
- Click Tools then Period End then Month End.
- Set the Month End date by choosing the last day of the month option > enter the first month you require depreciation postings for.
EXAMPLE: If the journals you reversed started in January 2023, enter 31/01/23.
- Select the Include depreciation of fixed assets check box then click Run Month End then Yes then OK.
TIP: Depreciation is posted only for those fixed asset records not already depreciated on or after the specified month.
- Repeat steps 2 to 4 for each month up to your latest month end.
Correct prepayments
If you miss a month for an automatic prepayment, you can't correct this and continue with the automatic postings. Instead you must delete the automatic prepayment, post manual journals for the missing month, then continue to make manual postings for the remaining period of the prepayment.
To delete an automatic prepayment
- Back up your data
- Click Nominal codes then Prepayments.
- Note the details of the entry you want to delete and select the entry.
- Press F8 then click Save then OK.
To manually post the prepayment journals
You must post manual journals for the missing month, and then each further month until the prepayment ends. For example, if the prepayment was for 10 months with 4 months already posted, there are 6 postings left including the missing month. This means you should post the missing month, plus 5 further monthly postings.
- Click Nominal codes then Journal entry.
- In the Reference field, enter PREPAY.
- In the Posting Date field, enter the last day of the missing month.
- Complete the Journal Entry window as follows, using the information you noted in the previous section:
N/C Details T/C Debit Credit Prepayments nominal code, 1103 by default. The information noted from the Details column. T9 The amount noted from the Monthly Amount column. The nominal code noted from the N/C column. The information noted from the Details column. T9 The amount noted from the Monthly Amount column. - Click Save then Close.
TIP: You can post the remaining months now, or each month as part of your month end routine.
- To post the remaining prepayment journals, for each required month, repeat steps 1 to 4 using the last day of the month as the posting date.
Correct accruals
If you miss a month for an automatic accrual, you can't correct this and continue with the automatic postings. Instead you must delete the automatic accrual, post manual journals for the missing month, then continue to make manual postings for the remaining period of the accrual.
To delete an automatic accrual
- Back up your data
- Click Nominal codes then click Accruals.
- Note the details of the entry you want to delete and select the entry.
- Press F8 then click Save then OK.
To manually post the accrual journals
You must post manual journals for the missing month, and then for each further month until the accrual ends. In the final month you must also post an extra journal to reverse the accrual. For example, if the accrual was for 10 months with 4 months already posted, there are 6 postings left including the missing month. This means you should post the missing month, plus 5 further monthly postings, then the reversal.
- Click Nominal codes then Journal entry.
- In the Reference field enter ACCRUE.
- In Posting Date enter the last day of the missing month.
- Complete the Journal Entry window as follows, using the information you noted in the section To delete an automatic prepayment or accrual:
N/C Details T/C Debit Credit Accruals nominal code, 2109 by default. The information noted from the Details column. T9 The amount noted from the Monthly Amount column. The nominal code noted from the N/C column. The information noted from the Details column. T9 The amount noted from the Monthly Amount column. - Click Save then Close.
TIP: You can post the remaining months now, or each month as part of your month end routine.
- To post the remaining prepayment journals, repeat steps 1 to 3 for each required month.
- In the final month of the accrual period, to post the accrual reversal,click Nominal codes then Journal entry.
- In the Reference field enter REVERSE .
- In Posting Date enter the last day of the month.
- Complete the Journal Entry window as follows, using the information you noted in step 2 of the section To delete an automatic prepayment or accrual:
N/C Details T/C Debit Credit Accruals nominal code, 2109 by default. Accrual Reversal T9 The amount noted from the Value column. The nominal code noted from the N/C column. Accrual Reversal T9 The amount noted from the Value column. - Click Save then Close.
Upgrading your licence
Need a little more room? To add extra companies, users, employees or more to your software licence, leave your details and we'll be in touch.