Article Summary: This practical guide outlines the precise steps and critical prerequisites needed to seamlessly import text-based accounting exports from Reservit PMS into Sage50 (Canadian Edition). You will learn how to configure matching validation parameters—such as date formats, decimal separators, and mandatory ledger codes—before initiating the import utility. Mastering this integration prevents strict system formatting blocks, saves valuable administrative time, and ensures highly accurate financial bookkeeping.
The 4 key steps to validate and import data into Sage50:
-
Validate System Prerequisites: Prior to importing, ensure every line has a valid accounting code in Reservit, set your Sage50 date format to DD-MM-YYYY, and confirm that your desktop accounting environment uses a dot (.) as the decimal separator.
-
Navigate to the Import Tool: Open your Sage50 software, click on the "Menu" toolbar options, and select the "Import/Export" module.
-
Select the Journal Option: Choose the designated option to "Import general journal entries into Sage50" from the available setup wizard.
-
Upload and Finalize: Select the specific
.txtledger file generated by Reservit PMS and execute the function; a system success message will instantly appear once the entries are fully populated.
Tip (Understanding the Export File Layout): > The exported Reservit text file structures data logically by line item. The first line contains the transaction date, entry number, and customer's full name (e.g.,
01-01-24,"20220934","Test Test"). The subsequent rows break down individual service details, taxes, payment methods, and corresponding internal accounting ledger codes (e.g.,4010,149.00).
Why follow this guide? Following this tutorial successfully bypasses the notoriously restrictive file validation rules embedded in Sage50, shielding your accounting team from annoying formatting rejections. It completely eliminates manual journal entry errors by ensuring a clean data sync between your PMS billing totals and your general ledger.
Alert: Sage is very restrictive when it comes to importing accounting entries. Before importing into Sage, you must validate the following points:
-
Make sure that all the lines in your export have an accounting code. To enter accounting codes in Reservit,
-
Make sure that the date format in Sage50 is the same as that in Reservit, i.e. DD-MM-YYYY.
-
Make sure that the decimal separator is the dot (.) in Sage50 as in the Reservit export.
Tip: Here is an example of the exported text:
01-01-24,"20220934","Test Test"
4010,149.00
2310,5.22
2340,7.71
2321,15.38
1125,-74.50
1125,-102.81
The first line shows the date, entry number and first and last name of the invoicing party. Underneath are details of each service, including taxes, payment method and related accounting code.
1. In Sage50, click on ''Menu'' then ''Import/Export''.
2. Select ''Import general journal entries into Sage50''.
3. Select the .txt file generated by Reservit
4. Once the import is complete, a success message will appear