root. Invoice Templates. December 16th , 2020.
This billing statement template can be used for invoice tracking, simple customer account management, and general billing. Although not as feature-packed as other small business billing software, it may be all you need. It has a column for recording the invoice number, a column for recording payments received from the customer, plus a generic amount column that can be used for all other charges, credits, debts, fees, etc.
This type of billing statement is useful when you receive regular payments from a customer, such as a tenant in one of your rental properties. It is very similar to our free invoice template, but unlike an invoice, a billing statement might also be used as an accounts receivable ledger for a specific customer, because it shows individual transactions and the current balance. See below for more information about using this template for invoice tracking.
This Billing Statement spreadsheet can be a simple alternative to other small business billing software. You can keep track of a customer account balance, track invoices and payments, and mail the statement to a customer to indicate a balance due.
Using the Billing Statement
Sending a Bill to a Customer
One of the critical features of accounts receivable software, invoice tracking software, and billing software is the ability to apply a customer's payment to a specific invoice or multiple invoices. The INVOICE column is meant for this purpose. If a payment applies to two or more invoices, just insert additional rows and split the payment between the different invoices. You will need to make sure the total payment sums correctly, but that isn't too hard to do with a calculator. To link the split payments together, in the TYPE column record the check number that the customer paid with (e.g. "C#2043") or include the check number in the description.
Any content, trademark/s, or other material that might be found on this site that is not this site property remains the copyright of its respective owner/s. In no way does LocalHost claim ownership or responsibility for such items and you should seek legal consent for any use of such materials from its owner.