Overview
The Bulk Import Debits & Credits feature allows you to upload multiple Other Credits and Other Debits into owner accounts using a standardized CSV template.
This feature is designed to streamline monthly accounting operations, such as recording utility charges, management fees, or one-time financial adjustments across multiple owners.
When to Use This Feature
Use bulk import when you need to:
Record recurring monthly expenses for multiple owners
Apply one-time financial adjustments across properties
Reduce manual data entry
Minimize input errors during month-end processing
Accessing the Feature
Navigate to Owner Report
Select Bulk Import Debits & Credits
Choose one or multiple owners
Select the applicable month and year
Note: Only owners with valid agreement periods for the selected month can be processed.
Step 1: Download the CSV Template
Click Download Template to obtain the required CSV format.
Do not modify the column headers or structure.
Required Fields
The following fields must be included:
Owner ID
Owned Room ID
Account (Other Credit or Other Debit)
Ref ID
Recognition Date
Item Name
Description
Amount
All required fields must be completed before upload.
Step 2: Upload the CSV File
Upload the completed CSV file (maximum 5MB)
The system will automatically:
Detect and map fields
Validate data format
Review the summary of:
Matched fields
Unmatched fields
Validation errors (if any)
Click Start Import to proceed.
Validation Rules & Common Errors
The import will fail if any of the following are detected:
Unsupported file format
Blank rows
Invalid Record Type
Missing required fields
File size exceeds 5MB
Errors must be corrected before re-uploading.
After Import
Once completed:
A confirmation popup will display the number of successfully imported records
You can navigate directly to the relevant Owner Report page
Important Notes
Records are created for the selected reporting month
Existing entries are not overwritten
If corrections are required, records must be adjusted manually after import
The system does not automatically merge duplicate entries
Best Practices
Always review the validation summary before confirming
Keep a local copy of the uploaded CSV for audit purposes
Use consistent naming conventions for Item Name and Description to maintain reporting clarity