JS320-FNA-XL ◉ APARTMENT RENTAL BOOKKEEPING

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?

1. Record tenant information and their rental duration
2. Record monthly tenant transactions
3. Record owner information. Useful for apartment manager who manage apartments with more than one owners.
4. Print invoices and cash receipts on any transactions
5. Track tenant receivable and owner payable
6. Generate financial report with standard accounting format automatically
7. 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

1. Company Info
2. Room List
3. Tenant List
4. Owner List
5. Supplier List
6. Receipt Number List
7. Asset List
8. Prepaid Revenue | Expenses
9. Financial Report

Transaction

1. Rental Payment
2. Other Income | Expenses
3. Internal Bank/Cash Account Transfer/Mutation
4. Depreciation

Receipt

1. Invoice
2. Cash Receipt

Account Payable/Receivable

1. Tenant Receivable
2. Owner Receivable
3. Supplier Payable

Report

1. Tenant Payment Report
2. Apartment Room Revenue Report
3. Profit & Loss | Monthly
4. Profit & Loss
5. Balance Sheet
6. Cash Flow
7. Equity
8. Assets
9. Cash Accounts
10. Dashboard