Ledger Validation for System Setup

Ledger Validation for System Setup

What is Ledger Validation?

This process allows you to upload base ledger data for residents in the system. Using this method, your residents' ledgers in ExactEstate start in the same financial state as the previous system you used. If you need to upload ledger details for historical entries, refer to our Ledger History Uploads guide.

Validation Rules for Ledgers

• Building: Enter the name of a building that already exists in the system. Ensure the building name matches exactly with what is in the system to avoid validation errors.
• Unit: Provide the unit number for a unit that is already entered in the system. The unit number should also match exactly with the system records.
• Balance: Enter the current balance for the resident ledger. This should reflect the amount prepaid or owed for the resident (e.g., 150.00 for credit, or -150.00 for a negative balance).
• Deposit On Hand: Enter the amount of deposit already held for the resident. This is typically the deposit amount collected prior to onboarding.
• Deposit Required: Enter the total deposit amount required for the resident. This value may differ from the "Deposit On Hand" if the resident owes additional deposit amounts.

Additional Notes

• Ensure that all building and unit entries match exactly with the data currently in the system or the System Setup Workbook.
• Double-check that balances are entered as numeric values (e.g., 150.00 for a credit balance or -150.00 for an owed balance).
• Ensure that Deposit On Hand and Deposit Required fields are populated according to the resident's current deposit records.

Helpful Tips

• Use the Ledger History Uploads feature to add historical ledger information if needed.
• If you're unsure about the required values for building or unit, verify them through the system before uploading.
• Review the spreadsheet format to ensure columns are correctly aligned with the expected validation rules.