Long Term Rentals: Monthly Rental Billings
Tips and Notes | Rent Out Equipment | Rental Returns
Pro
Use this procedure to send your rental customers monthly billing statements using your QuickBooks financial software. This example is for piano rentals by the month; adjust for your needs.
When you run financial exchange with QuickBooks after renting a piano, the customer (if new) is added to QuickBooks, enabling you to use account charges for future monthly billings. Typically, you would do monthly billings on a set day of the month for all rental customers.
To send out monthly rental billings:
Set an account limit for the customer. We suggest this be equal to at least two months additional rental charges.
In Point of Sale, display your sales order list filtered for pianos currently rented out (as explained here).
Select a rental sales order and then select Sell Items from the I Want To menu.
Enter a Doc Qty of one for the "Piano Rental Charge" item and select OK. This charges the customer for one additional months rent.
As necessary, increment the order quantity on the sales order for the rental charge item, so that some months always remain due. This prevents the sales order from being automatically closed if you "sell" all of the initial months entered.
On the sales receipt, take payment by account charge and save.
Repeat for all your open rental sales orders.
Conduct a financial exchange with QuickBooks.
The new monthly rental charges are posted to each customers account in your financial software.
Generate customer billing statements from QuickBooks and send to your customers. (Refer to your QuickBooks documentation for directions.)
When payment is received from a customer, take payment on account.
On the next financial exchange with QuickBooks, the customers account balance will be adjusted to reflect the payment and the new balance will be sent back to Point of Sale.
Notes:
You can also create and mail Customer Invoices from Point of Sale if you prefer, using the write letters capability. Create your own invoice template using Word and inserting the customer account fields you need.
Run Financial Exchange with QuickBooks