Owner invoices and monthly statements with ChatGPT or Claude

Updated

If you manage vacation rentals for their owners, every month ends the same way: one invoice per owner for your commission, a statement showing what their properties earned, and a spreadsheet to update. With ChatGPT or Claude connected to Nowistay and to your accounting software, this takes one message. The assistant reads the month’s bookings in Nowistay, applies each owner’s commission model, creates the invoices in your accounting software, writes the owner statements and fills in your tracking sheet. You check, then you send.

This guide follows a US property manager using QuickBooks Online. If you use other software or work in another country, see accounting software by country.

How it works

PieceWhat it brings
NowistayThe month’s bookings with their amounts: total, cleaning fee, tourist tax and platform commission
A project in ChatGPT or ClaudeYour owners, their billing details and each owner’s commission model, set up once
QuickBooks OnlineCustomers, invoice numbers, sending and payment tracking

The assistant reads and calculates. QuickBooks issues the invoice. Nothing is sent until you ask for it.

Why the invoice should come from your accounting software

A PDF written in a chat makes a good owner statement, but not a reliable invoice: nothing guarantees that its number follows the previous one, and it never reaches your books. When the assistant creates the invoice in QuickBooks instead, the invoice gets its QuickBooks number, shows in your receivables and is matched when the owner pays.

There is no federal invoice format in the US, but your records still have to add up at tax time:

  • As the property manager, you report the rent you pay over to each owner on Form 1099-MISC (box 1, Rents) when it reaches $2,000 for the year (tax years from 2026). The monthly statements below give you each owner’s yearly total. See the IRS instructions for Form 1099-MISC.
  • Whether sales tax applies to management fees depends on your state. Check with your state’s department of revenue and, if it applies, add the rate to your commission model.

Before you start

Step 1: Connect QuickBooks Online

In Claude

  1. On claude.ai, select Customize in the left sidebar, then Connectors.
  2. Find Intuit QuickBooks and select Connect.
  3. Sign in with your Intuit account, choose your QuickBooks company, then the permissions you grant Claude.

In ChatGPT

  1. Select Plugins in the left sidebar and search for Intuit QuickBooks.
  2. Select Connect Intuit QuickBooks and sign in to your QuickBooks Online account.
  3. Check that you are signed in to the right company, then select Start chat.

The connection works with one QuickBooks company at a time. To work on another company, reconnect and choose it.

Step 2: Create an “Owner billing” project

A project keeps your instructions and your owner sheet, so every chat you start in it already knows them.

  • ChatGPT: select New project in the sidebar and name it “Owner billing”. To add the instructions, open the project’s ••• menu, then Project settings.
  • Claude: open Projects, select + New Project and name it “Owner billing”. Select Set project instructions, paste the instructions, then Save instructions.

Paste these instructions, with your own company details:

You prepare the monthly owner billing of Sunset Coast Rentals LLC, 450 Ocean Drive, Miami FL 33139.

- Bookings and amounts come from Nowistay only. Never estimate or invent an amount: if one is missing, list the booking and ask me.
- Owners, billing details and commission models are in owners.xlsx in this project. If a property or a rule is missing, ask me. Never guess.
- Invoices are created in QuickBooks: one invoice per owner and per month, one line per stay.
- Always show me the calculation table and wait for my OK before creating anything.
- Never send an invoice or an email unless I explicitly ask for it.
- Round each commission line to the cent. The total is the sum of the rounded lines.

Step 3: Let the assistant interview you and build your owner sheet

You don’t fill in a spreadsheet yourself. The assistant starts from your property list in Nowistay, asks you the questions and builds the sheet from your answers. In a new chat inside the project, send:

Let’s set up my owner billing. Read my properties in Nowistay. Then ask me, one property at a time, who the owner is (person or company), their billing address and email, and how my commission works for them. When a property probably works like the previous one (same owner, same contract), suggest the previous answers so I can just confirm. Then check the commission model on a real stay from last month and show me the calculation. When everything is confirmed, create owners.xlsx with one row per property.

The commission questions come in plain words, for example:

  • What do you take your percentage on: the whole stay, the stay without the cleaning fee, or what is left after the platform’s commission?
  • Who keeps the cleaning fee: you (for your cleaning team) or the owner?
  • Which month does a stay count in: the month of check-out, of check-in, or each month for the nights spent in it?
  • Do you take a commission on a cancelled stay that still paid out? A different rate on direct bookings? A minimum monthly fee?
  • Do you charge sales tax on your commission?

The assistant then checks that it understood, on a real booking: “Ocean View 2B, Airbnb, Oct 3 to 7, total $754: your commission would be $120.00. Is that right?” If the figure is wrong, say why and it corrects the rule.

Example of the sheet it builds:

Property (as in Nowistay)OwnerBilling addressCommissionCalculated onCleaning feeA stay counts inNotes
Ocean View 2BJane Miller18 Bay Rd, Tampa FL 3360620%Stay without cleaning feeKept by managerCheck-out month
Ocean View 3AJane Miller18 Bay Rd, Tampa FL 3360620%Stay without cleaning feeKept by managerCheck-out month
Palm CottageMiller Family Trust200 Main St, Sarasota FL 3423618%After platform commission, without cleaning feeKept by managerCheck-out monthMinimum $150 per month
Harbor LoftCoastal Homes LLC75 Harbor Way, Miami FL 3313125%Whole stay, cleaning includedPaid to ownerNights in each monthDirect bookings: 15%

The real file also holds each owner’s email and payment terms.

Add the sheet to the project. Neither assistant saves a file into a project on its own: download owners.xlsx, then add it to the project’s files in ChatGPT, or with the + button of the project knowledge panel in Claude.

When something changes, say it in the project: “Palm Cottage goes to 20% from December” or “Add the owner of Bayfront Studio”. The assistant asks what it needs, gives you the updated owners.xlsx, and you replace the old file in the project.

With only 2 or 3 properties, you can skip the file: ask the assistant to write the table as text and paste it at the end of the project instructions.

How your commission is calculated

What Nowistay records on each booking

AmountWhat it contains
Total amountWhat the guest paid for the stay: accommodation, cleaning fee and tourist tax. A service fee the platform charges the guest is not included: it goes to the platform.
Cleaning feeThe booking’s cleaning fee.
Tourist taxOccupancy and tourist taxes, whether the platform collects them or you do.
Platform commissionWhat Airbnb, Booking.com, Expedia or Agoda charge you, Booking.com payment fees included. None on direct bookings.
AccommodationNot stored on its own: the total amount minus the cleaning fee and the tourist tax.

The three usual bases, on one example

An Airbnb stay of 4 nights at $150, with a $100 cleaning fee and $54 of occupancy tax collected by Airbnb. Airbnb’s commission on the booking is $108.50. Nowistay records a total amount of $754.

Commission calculated onCalculationBase20% commission
The whole stay, cleaning includedtotal − tourist tax$700.00$140.00
The stay without the cleaning feetotal − cleaning fee − tourist tax$600.00$120.00
What is left after the platform, without the cleaning feetotal − cleaning fee − tourist tax − platform commission$491.50$98.30

The tourist tax stays out of the base: it belongs to the city or the state, not to the owner or to you.

From your commission to the owner’s payout

With the second base, and the cleaning fee kept for your cleaning team, the owner’s statement for this stay reads:

LineAmount
Airbnb payout (total − tourist tax − platform commission)$591.50
Cleaning fee kept for the cleaning team−$100.00
Management commission (20%)−$120.00
Due to the owner$371.50

Rules worth settling once

  • Stays over two months: a stay from October 30 to November 3 counts in October if you bill on check-in, in November if you bill on check-out, or 2 nights in each month if you bill the nights spent in each month.
  • Cancellations: if a platform still paid out for a cancelled stay (non-refundable rate, cancellation fee), check the amount on the platform and tell the assistant whether you take your commission on it.
  • Direct bookings: they carry no platform commission. Your payment provider’s card fees are not in Nowistay: if your contract deducts them, give the assistant the rule.
  • Minimum fee or flat fee per stay: write it in the Notes column and the assistant applies it.

Step 4: Prepare the invoices and statements each month

In a new chat inside the project, send:

Prepare the October 2026 owner billing.

  1. In Nowistay, read every stay of the properties in owners.xlsx that counts in October under each owner’s rule.
  2. Show me one table per owner: property, guest, channel, dates, nights, total amount, cleaning fee, tourist tax, platform commission, base and commission. Flag any stay with a missing or zero amount.
  3. Wait for my OK.
  4. In QuickBooks, create the owner as a customer if needed, then one invoice per owner dated October 31, due in 15 days, with one line per stay (“Management commission, Ocean View 2B, Oct 3-7, Airbnb”). Don’t send anything.
  5. Write each owner’s October statement as a PDF: stays, revenue, platform commission, cleaning, my commission with its QuickBooks invoice number, and the amount due to the owner.

You get:

  • The calculation table, owner by owner, to check before anything is created.
  • The invoices in QuickBooks, created but not sent. Open them in QuickBooks to check or edit them.
  • One PDF statement per owner, ready to attach.

When everything is right, send the invoices from QuickBooks, or ask: “Send the October invoices to the owners.” Sending is always a separate request.

Update your tracking spreadsheet

If you keep a monthly sheet of what each owner earned, the same chat can fill it. Give it your exact columns:

Give me October’s rows for my tracking sheet, with exactly these columns: Month, Owner, Property, Stays, Nights, Revenue, Platform commission, Cleaning, Commission, Invoice number, Due to owner. As an .xlsx file.

Then, depending on where your sheet lives:

  • Google Sheets: import the file into your sheet (File > Import). The assistant can also write in the sheet directly: in ChatGPT through the Google Drive app connected with edit access, in Claude with the Claude for Google Sheets add-on (Extensions > Claude > Open Claude) on the open sheet.
  • Excel: paste the rows into your workbook, or open the Claude for Excel or ChatGPT for Excel add-in in the workbook and ask it to add them.

Run it automatically every month

Once a month has gone well by hand, you can schedule it. The scheduled run prepares everything: the calculation, the invoices in QuickBooks (not sent), the statements and the sheet rows. You check, then you send.

Write the scheduled task so that it works on its own, for example:

Prepare the previous month’s owner billing, following the instructions and the owners.xlsx sheet of my Owner billing project. Create the QuickBooks invoices without sending them, write the PDF statements, then send me a summary per owner, with every stay that has a missing amount.

  • Claude (paid plans): open Scheduled in the sidebar and select New task. The repeat options are hourly, daily, weekly and weekdays: choose weekly on Monday and start the task with “Only on the first Monday of the month, otherwise stop.” Scheduled tasks use your connectors and run even when your computer is off. Keep a copy of owners.xlsx in your Google Drive and connect Google Drive, so the task can always open the sheet.
  • ChatGPT: run the monthly request once in agent mode. When it is done, select the clock icon on the task to repeat it every month. Your scheduled tasks are listed in Settings > Notifications > Manage tasks.

Actions that create something in QuickBooks can wait for your approval during a scheduled run: approve them when you review the month, then check the first scheduled run closely.

Check the figures before you send

  • Bookings imported when you connected a channel only carry the accommodation price: no cleaning fee, tourist tax or platform commission. Open the booking, click the pencil in the Financial section and fill in Cleaning, Tax and Total amount. Give the assistant the platform commission shown in the platform’s payout.
  • Vrbo bookings: compare their amounts with the Vrbo payout.
  • Direct and manual bookings: the amounts are the ones you entered.
  • Stays over two months: check that they follow each owner’s rule.
  • A mistake on an invoice: correct it in QuickBooks before sending. Once an invoice is sent, issue a credit memo and a new invoice rather than editing it.

Let owners check their own numbers

Owners can connect their own ChatGPT or Claude to Nowistay, read-only, to see the bookings and monthly performance of their properties. See how to let property owners ask ChatGPT or Claude about their properties. When both sides read the same figures, questions about a statement are settled faster.

Accounting software by country

The situation in November 2026. An official connector is published by the software company itself. Connectors built by third parties send your accounting data through another company: prefer the official ones.

CountrySoftwareOfficial connectorWhat the assistant can doGood to know
United StatesQuickBooks OnlineChatGPT and ClaudeCreate customers and invoices, send them on requestUS customers only
United KingdomZoho BooksClaude (directory), ChatGPT (custom connector)Create and send invoicesXero’s connectors only read data. Structured e-invoices required from April 2029
FranceQontoClaude (directory), ChatGPT (custom connector)Draft, finalize, send invoices, including as e-invoicesPennylane’s connector only reads data. E-invoicing reform from 2026
BelgiumOdooCustom connector, to set upRead and write recordsPeppol e-invoices required between businesses since January 2026
GermanyQontoClaude (directory), ChatGPT (custom connector)Draft, finalize, send invoices (XRechnung, ZUGFeRD)Lexware Office and sevDesk have no official connector. E-Rechnung between businesses from 2027
SpainQontoClaude (directory), ChatGPT (custom connector)Draft, finalize, send invoices (VERI*FACTU)Holded has no official connector. VERI*FACTU software required from 2027
ItalyQontoClaude (directory), ChatGPT (custom connector)Draft and finalize invoicesEvery invoice must go through the SdI. Fatture in Cloud has no official connector
NetherlandsMoneybirdClaude (directory), ChatGPT (custom connector)Create contacts and draft invoices, sent from MoneybirdNo e-invoicing obligation yet
PortugalInvoiceXpressClaude (custom connector)Issue certified invoices (ATCUD, QR code)Invoices must come from certified software

In Claude, a directory connector is added from Customize > Connectors. In ChatGPT, a custom connector is added after turning on developer mode in the settings, and creating or changing data through it depends on your plan: check yours.

Frequently asked questions

They can write one, but a PDF made in a chat has no guaranteed numbering and doesn’t reach your books. In several countries (Italy, Portugal, and soon Spain, and France for business customers) an invoice must come from compliant software. Let the assistant calculate and prepare, and let your accounting software issue the invoice.

Is my commission calculated on the cleaning fee?

Only if your contract says so. Nowistay records the cleaning fee separately, so the assistant can include it or leave it out. Tell it once, when it interviews you, and it is saved in owners.xlsx.

What if an owner has several properties?

The assistant makes one invoice per owner, with one line per stay, grouped by property. If you prefer one invoice per property, tell it during setup.

Do I have to give the owners’ details again every month?

No. They are saved in owners.xlsx, in the project. You only update the sheet when an owner or a contract changes.

Can the invoices be sent automatically?

The connectors can send invoices, but keep sending as your own step: let the scheduled run prepare the invoices, then check and send them yourself.

Is my owners’ data used to train the AI?

On ChatGPT Business and Enterprise, and on Claude Team and Enterprise, your data is not used for training by default. On personal plans, turn off model training in the privacy settings. Nowistay only shares what each request needs, and guests’ contact details are left out unless you ask for them.

Ready to Put Your Rental on Autopilot?

Join 1,000+ property managers who save hours every week with AI-powered guest communication.