Importing Trial Balances
Before you start you should be familiar with the Chart of accounts:
Navigate to the Journal Entry list and click the "Add New Journal Entry" or use the plus button on the left nav bar:
Select the Property/Company you want to add the Journal Entry for.
Always date the Trial Balance for the end of the month. In RAAMP on date fields you can type just the numbers if you leave off the year it will fill that in for you. so for April 30th 2022 you can type 0430 and it will fill in the slashes, if you wanted a previous year you could type 04302019 and will recongnize the correct year.
Add the entry number a common standard if to type JE-04302019 using the date, but you can number it based on your operational standards.
If the Trial Balance shows the Actual Debit or Credit that was the activity for the period, you can enter the Trial Balance as a Typical Journal Entry.
If the Entry is not in balance it will not be included in reports until it is.
If the Trial Balance you are importing only has the ending balances rather than the actual activity you will need to use the Trial Balance import, this is very common when importing Trial Balances from QuickBooks. You will need to click Import Data.
Click Download Template (NOTE: Templates are specific to the Property/Company so you will not be able to use the same template for different properties or companies)
Fill out the Template and save
Upload your template. You can drag the file to the upload Template section or click the area to browse your local files.
Once the file starts you will see a progress window:
Once completed the entry will have been adjusted to Debit and Credits. After success or failure a result of the import will appear in your downloads folder:
Click Save
You will want to inspect you balance sheet and P&L for the date of your entry. matching to your historicals.
Related: