Description
Apartment Rental Bookkeeping for Non Accountant is an Excel spreadsheet for non accounting people to record financial transactions and generate financial reports for apartment rental business. It should fit you who rent your apartments for long term tenants, either as a landlord or apartment manager.
How can this spreadsheet accommodate apartment rental business financial transactions?
There are simple transaction worksheets where you can entry your tenants and their transactions data easily. Also, you can put other financial data related with your apartments. All recorded transactions will be mapped in financial statements with standard Accounting format automatically. Fits to any small business owners and employees who don’t have time to learn accounting but want to generate professional report like Accounting people do.
No need to calculate depreciation manually.
No need to set the report.
Just type transactions and financial reports are ready for further analysis.
It is not just a profit and loss spreadsheet. It is a complete financial statement spreadsheet.
What you can do with this spreadsheet?
- Record tenant information and their rental duration
- Record monthly tenant transactions
- Record owner information. Useful for apartment manager who manage apartments with more than one owners.
- Print invoices and cash receipts on any transactions
- Track tenant receivable and owner payable
- Generate financial report with standard accounting format automatically
- View apartment financial status in Dashboard visualization
Apartment Rental Bookkeeping Spreadsheet prices are based on number of apartment rooms with Single and Multi User License. There are 4 available room categories now. Those are : 25, 50, 75 and 100 rooms models.
List of Modules
Front Menu
Setup
- Company Info
- Room List
- Tenant List
- Owner List
- Supplier List
- Receipt Number List
- Asset List
- Prepaid Revenue | Expenses
- Financial Report
Transaction
- Rental Payment
- Other Income | Expenses
- Internal Bank/Cash Account Transfer/Mutation
- Depreciation
Receipt
- Invoice
- Cash Receipt
Account Payable/Receivable
- Tenant Receivable
- Owner Receivable
- Supplier Payable
Report
- Tenant Payment Report
- Apartment Room Revenue Report
- Profit & Loss | Monthly
- Profit & Loss
- Balance Sheet
- Cash Flow
- Equity
- Assets
- Cash Accounts
- Dashboard