The Creditor EFT Export will include all deductions for the chosen Creditor up to the Process Date that are yet to be included in an EFT File. If this is higher than expected, this can happen when:
Regenerate Processed Records is ticked. This will include all previous periods in the current Financial Year.
A Manual Calculation Subtract does not reduce and therefore will overstate the amount. You will need to manually reduce the amount.
Or previous periods haven't been exported either because:
The Creditor EFT Audit Report was previewed, but the file was not actioned.
Or a restore was completed to a point prior to the previous Creditor EFT.
Check if a Restore has been completed
Log in as an Admin user.
Go to Access MicrOpay Administration, System Tools, Message Log Viewer.
Select Application from the Log.
Review the data to see if a restore has been completed.
Clear the previous Creditor EFT
Take a backup.
Go to Payroll, Transactions, Import and Export, Creditor EFT Export.
Enter the required parameters.
Enter the Process Date as the last period end date that you need to clear. These are the ones you don't want to include in your current EFT File.
Click Preview and check the values.
Close the Preview.
Click EFT File. This will generate the file for the previous periods. If you have already paid this, discard the file.
Close the Report Preview.
Select the current period as the Process Date.
Click Preview and check the values.
Close the Report.
If the values are correct, click EFT File.
To ensure that the data has been updated after generating the file, go back into the creditor, and the period end date should no longer be listed in the Process Date.