Tenant Ledger

Export your data to QuickBooks

Once QuickBooks is connected and your data is linked, you can send your TenantLedger records — charges, payments, bills, bill payments, miscellaneous transactions, and refunds — into QuickBooks Online with a few clicks. Export is manual and one-directional: you choose what to send, and TenantLedger pushes it to QuickBooks. It never pulls data back or changes your TenantLedger records.

Before you start

  • QuickBooks must be connected. See Connect QuickBooks.
  • Your data must be linked (see the next section). Records that aren’t linked can’t be exported, and the export will tell you exactly what’s missing.

Linking tells QuickBooks which of its records each of your records corresponds to, so amounts land in the right place.

  1. On the QuickBooks settings page, click Open link wizard.
  2. Work through each link type — the wizard groups them into sections:
    • Accounts — your TenantLedger chart-of-account categories matched to QuickBooks accounts.
    • Customers — your tenants, including moved-out (inactive) ones, matched to QuickBooks customers.
    • Vendors — your vendors matched to QuickBooks vendors.
    • Banks — your bank accounts matched to QuickBooks bank/payment accounts.
    • Items — your income accounts (the charge types) and your Security Deposit Liability account matched to QuickBooks items. In QuickBooks, point the security deposit item at your security-deposit liability account, not an income account.
  3. For each row, link it to the matching QuickBooks record (or create the match). A linked row shows a green Linked badge; an unlinked row stays blank until you link it. You can change a link later from the same wizard.

You only have to do this once, then keep it up to date as you add new accounts, tenants, or vendors.

Step 2 — Send your records

  1. In the top navigation bar, click the Settings gear, then click Settings (or use Settings in the left sidebar).

  2. Click the QuickBooks tile.

  3. Under Export your financials, click Manually send to QuickBooks.

  4. Use the filter area to narrow the list:

    • Status — choose Needs to be Exported (the default) to see records not yet sent, or All, Up to Date (already sent and unchanged), Needs to be Updated (sent, then edited in TenantLedger), or Record in QuickBooks by hand (payments TenantLedger doesn’t export; see “Payments you record in QuickBooks by hand” below). The list shows only records with the status you pick, for every type.
    • Type — All, or a single type: Bill, Bill Payment, Charge, Payment, Miscellaneous Transaction, or Refund.
    • Date Range — required. It finds records created or last changed in that period, not by transaction date, so an older charge you edited today shows up in today’s range.
  5. Click Search to load the matching records.

  6. Review the list, then export the records you want sent to QuickBooks.

What you’ll see

Each record carries a status label so you always know where it stands:

  • Needs to be Exported (red) — not yet sent to QuickBooks.
  • Up to Date (blue) — already sent, and unchanged since.
  • Needs to be Updated (yellow) — sent before, then edited in TenantLedger, so QuickBooks is out of date until you re-export it.
  • Record in QuickBooks by hand (grey): a payment TenantLedger doesn’t export, with the reason underneath. It has no Export button, and Export selected skips it.

A success message confirms each record that was sent, and exported items move to Up to Date so they won’t be sent twice. If a record can’t be exported — most often because something it depends on (an account, customer, or vendor) isn’t linked yet — you’ll see a clear error naming exactly what to link first.

How each record lands in QuickBooks

  • Charges become invoices, using the QuickBooks item linked to the charge type. A charge that belongs to the whole lease (rent shared by “Multiple Tenants”) is invoiced to the lease’s primary tenant, meaning the first tenant added to the lease. The list marks these rows Shared; link that tenant’s customer before you export them. Once a shared charge is in QuickBooks, it keeps that customer even if the tenant later leaves the lease.
  • Payments become QuickBooks payments applied to the invoices they paid, under the same customer as those invoices, so export the charges first. Payments land in Undeposited Funds. TenantLedger deposits aren’t exported, so record the bank deposit in QuickBooks from Undeposited Funds. If one payment covers both a shared lease charge and a co-tenant’s own charge, QuickBooks can’t hold it as a single payment; the export tells you, and you record that one in QuickBooks with Receive Payment.
  • Miscellaneous transactions become sales receipts with no customer, using the item linked to their income account. They also land in Undeposited Funds.
  • Bills and bill payments become bills and bill payments for the linked vendor.
  • Refunds become refund receipts paid from the linked bank account. Income refunds and security deposit refunds are exported. A security deposit refund uses the same item as your security deposit charges, and it’s only exported when that item points to a liability account in QuickBooks; otherwise the export tells you to fix the item first. Other refunds, such as prepaid rent, don’t appear in the list.
  • Not exported: deposits, credits applied in TenantLedger, and the payments described in the next section. A charge paid off with a credit stays open in QuickBooks until you apply a matching credit there.

Payments you record in QuickBooks by hand

Some payments don’t bring any money into your bank, or can’t be matched to invoices in QuickBooks. TenantLedger doesn’t export them, because as QuickBooks payments they would add money you never received to Undeposited Funds or fail to apply. They show Record in QuickBooks by hand, with one of these reasons:

  • Paid from security deposit: you applied part of a tenant’s security deposit to their charges, for example damages at move-out. In QuickBooks, create a credit memo on your security deposit item (the one that points to your security deposit liability account) for the customer the invoices are billed to, then use Receive Payment to apply the credit memo to those invoices. That lowers the deposit liability the same way TenantLedger did. For rent shared by the whole lease, that customer is the lease’s primary tenant.
  • Paid from prepaid rent: you applied a tenant’s prepaid rent to their charges. In QuickBooks, apply it against wherever you recorded the tenant’s prepayment, for example by using Receive Payment to apply the tenant’s credit to those invoices.
  • Part not applied to a charge: part of the payment wasn’t applied to any charge. Usually that’s prepaid rent; a payment brought in by data import can also hold an unallocated amount. Record the payment in QuickBooks with Receive Payment for the charges it paid, and book the rest the way TenantLedger shows it (prepaid rent, for example, as a credit for the tenant).

TenantLedger keeps prepaid rent in a liability account. If your accountant books it to a liability account in QuickBooks too, rather than as a customer credit, follow their method. The amounts are on the payment in TenantLedger.

If an earlier export already sent one of these payments to QuickBooks, its Exported? column shows Yes, as cash. Remove that payment in QuickBooks, then record it by hand as described above. Check first whether it’s part of a bank deposit or a reconciled period; if it is, ask your accountant how to correct it rather than deleting it.

Tips

  • If an export fails because something isn’t linked, go back to the link wizard, match the missing item, then return and try the export again.
  • Use the Needs to be Updated status to find records that changed in TenantLedger after they were first exported, so QuickBooks stays accurate.
  • Export in batches by Type and Date Range if you have a lot of history — it’s easier to review what went across.
  • Export in order: charges before the payments that pay them, and bills before their bill payments.
  • Nothing is sent on a schedule. Every export starts when you click Export, and a failed export is never retried on its own, so you stay in control.

Still stuck? Email support@tenantledger.com and a real person who knows the product will help.