Quickbooks for Vacation Rental Properties

[Jowan Qupty]

Hi All,

I am currently managing and automating my daily vacation rental tasks through Airtable, which I have connected to a number of online softwares through their API's (Gmail for emails, Twilio for SMS's, Slack for Notifications....etc) in order to achieve my desired custom workflows, and cut down on time spent in front of a computer.
I am now at the point of automating my vacation rental bookkeeping tasks and would be grateful for any help with the following:

I would like to automatically create a QuickBooks Online Invoice for each customer as soon as they pay for the reservation.
(i.e: Customer Name: John Doe, Amount: $1,000)

At the end of the month, when I am reconciling my bank account, I would ideally like to match the payment received from John Doe to the invoice in QuickBooks. However, the amount that is deposited into my bank account is $1,000 - $ 25 (Credit Card processing fees) = $975, it is therefore not possible to match it with a $1,000 invoice.

Does anybody know how I can make this work? Alternatively, do you have a better/easier solution?

Thanks in advance for any feedback or advice!