To begin migrating vendor's invoices, follow these steps:
- Go to the settings menu and select "vendor's invoice migration."
- Download the CSV sample file provided and save it in a dedicated folder. This file will be used to upload the unpaid vendor invoices that are still outstanding as of the cut-over date, similar to the process for sales invoices.
Next, populate the CSV file with the necessary information, making sure to remove the sample data. Once you have completed this step, it is important to have a designated checker validate your data entries before proceeding with the file upload.
To upload the file please click on “confirm and migrate all data”. After uploading the file, the vendor profiles will be updated, reflecting the amount due to each vendor as of the cut-over date. These amounts will be recorded as the opening balance of trade payables on the general ledger for the post-migration period.
Important Note:
In order to ensure that outstanding invoices are properly migrated as the opening balance in the new financial year or post-migration period, it is crucial to follow these guidelines:
Example 1: End of Year migration: For the Financial Year ending on December 31, 2023, All invoices need to be dated no later than December 31, 2022, and will be treated as the opening balance on January 1, 2023.
Example 2: Migration in the middle of the financial year, with a cut-over date of June 30, 2023: For the Financial Year ending on December 31, 2023, All invoices need to be dated no later than December 31, 2022, and will be treated as the opening balance on July 1, 2023. Please note that although these invoices may not be considered overdue, they will appear as such in individual customer accounts.