You can create reversing journals directly from Microsoft Excel workbooks using the Access Office Integration (AOI) journal template.
Assuming you have AOI installed and that your AOI licence has the Journal Uploader feature enabled, then you can create a journal for posting to Access Financials as follows:
Create a new empty workbook in Excel
Click the Access menu
In the Uploaders menu, click on Create Sheet
Select NL Journal
This will create a fresh journal template
In the Uploaders menu, ensure you have the correct destination connection selected
Enter a date for the journal in the Date cell
Enter a Journal Ref (up to 10 chars long)
Enter a Description
In the Reverse with 2nd Transaction option, select Yes. This will generate an additional (second) opposing journal that will reverse your first journal in the next period after the chosen period for the first journal.
Enter the required Year and Period for the initial/first journal
Select a Type
In the Batch option, select Yes if you wish to save the journal to batch. If you save it to batch, it will be posted to the Financials Journal Batch where you can view and edit the journals prior to posting. Otherwise, if you select No then the journals will be posted direct to the ledger.
Enter a Batch Ref - if required
Enter the required Nominal Codes and values in the detail rows below. The debits and credits must balance.
When ready, click Validate & Process and select either Validate only or Validate & Process
Your journal and the additional reversing journal will then be posted to the batch or direct to the ledger, depending on your chosen setting.
Save your workbook. You can then reuse the same workbook for posting future journals.