Journal Entry Upload
It is possible to create journal entries inside RoomBoss by a direct upload from Excel.
Last updated
It is possible to create journal entries inside RoomBoss by a direct upload from Excel.
Last updated
The Upload is done via the Add Journal Entries page.
Navigate >> Trust >> Add Journal Entries
In the Bulk Add Journal Entries area, click Download Template File.
The downloaded file will contain 2 tabs:
A Journal Entries tab for adding the Journal Entries you wish to upload.
An Accepted Values tab listing the accepted values for the OWNER(DISTRIBUTION), LEDGER and ACCOUNT columns on the Journal Entries tab.
The upload is prepared by entering the values into the Journal Entries tab. Eg:
Debits and credits to owners can be:
Direct to an individual Owner - by using a value from the Owners column in the template.
Distributed across active owners in a Vendor - by using a value from the Vendors column in the template.
Distributed across active owners in a Room Type - by using a value from the Room Types column in the template.
Distributed across active owners in a Pool - by using a value from the Pools column in the template.
Where a charge is direct to an individual owner, the full amount will be debited/credited to the owner.
Where a charge is distributed over a vendor, a room type, or a pool, the amount will be distributed across the active ownerships.
Any rounding amounts from the split will be credited to a rounding account on the MANAGER ledger.
By default, the distribution will be equal across all owners in the vendor / room type / pool. However, it is also possible to setup entitlements to give relative weights for each unit. Where entitlements exist, amounts will be distributed based on this.
Entitlements can be managed via Trust >> Trust Entitlements.
Upload by clicking the +XLSX button and choosing the file to upload then clicking Upload. This will create the following Journal Entries:
If there is a problem with the upload, no Journal Entries will be created and you will see:
Failed to post journal entries! Please download the Excel file and check your inputs.
To check your upload, download the file showing the errors by clicking Download File Marking the Errors.
This will give a file with the errors marked in yellow. Eg:
Column J indicates if the row is OK or contains an ERROR.
Row 2 – Issue with the date (no period is open for April 2019)
Row 3 – No Error
Row 4 – Issue with the values (the debit and credit amounts must be the same)
Row 5 – WAT is not one of the accepted Account values
Row 6 – No Error
Row 7 – Man is not one of the accepted Ledger values
Correct the errors and upload again.
