Prepare your source records
A clear starting point for your transaction import.
Use the RentariIQ CSV layout to bring a bank or credit-card statement into your paid portfolio. Review the file before you upload and the imported rows before booking.
An active paid portfolio is required. You will be asked to sign in or manage billing if needed. The file includes fictional example rows to replace with your records.
Four columns. One source account.
Keep the original statement nearby.
The template brings in transactions. It does not import formulas, worksheets, receipts or a finished general ledger.
- Date
- Description
- Amount
- Memo
Prepare each column.
Use a separate upload for each source account. Choose the correct bank or card account in the app before importing.
| Column | What to enter | Check before importing |
|---|---|---|
| Date | The statement transaction date, such as 01/15/2026. | Use an unambiguous format consistently. Check the year and reporting period. |
| Description | The original payee or statement description. | Preserve useful source text for matching and review. |
| Amount | A signed amount in dollars, with two decimal places. | Positive means money in or a card refund. Negative means money out or a card purchase. Check refunds and payments against the statement. |
| Memo | An optional supporting note. | Do not put passwords, full card numbers or unrelated personal data in the file. |
Work from a copy
Keep the source workbook unchanged. Replace both fictional sample rows in the downloaded file. Remove subtotal rows and statement balances from the transaction list; those are controls for your review, not new payments.
Inspect a small date range
Start with a few transactions. Confirm dates, descriptions and signed amounts in the import feed. Compare the rows with the statement before expanding the range. Check any existing entries so a manual payment and an imported row do not become two bookings.
Review the accounting separately
Assign the transaction type, category and property. Existing matching rules and loan templates may automatically book eligible rows, so inspect booked results as well as the remaining feed. Reconcile the account after the complete statement is entered.
Working with a property-manager statement?
Manager statements can contain gross rent, fees and a net owner payout. They use a different review workflow. Do not treat each statement line and its bank payout as separate rental income.
Review manager statement imports