What you need to track in your online invoice tracker.
How to create an invoice tracker.
An easy way to create your own invoicing tracking template is by using an Excel spreadsheet. With an Excel spreadsheet, you can organize your billing in multiple ways. While a ledger is usually kept chronologically according to date, an online tracker can filter your invoices based on name, receivable, date, receipt number, and more. When creating your invoice tracking template, it’s a good idea to start by including the following:
- Invoice number. There are a variety of ways to assign invoice numbers, so choose the one that works best for your business. No matter how the number is formatted on the actual bill, consider using a standard number of digits. So, instead of entering numbers ‘99’ or ‘100,’ use ‘00099’ and ‘00100.’
- Customer. If you organize your customers by name, enter that information here. Some vendors assign repeat clients a unique number. If this is true for your business, make sure you include that number with the client name.
- Invoice date. While your bills may include dates for services, you generally won’t use a service date on your tracker template. For your Invoice Date, use the date that you issued the invoice.
- Due date. This is the date the total amount is due. Pro tip: In order to avoid confusion and potential late payments, it’s a good idea to list your payment terms directly on the invoice.
- Amount. The amount is the grand total due, including any taxes or fees for things like delivery.
- Amount paid. Even if your business doesn’t accept partial payments, it’s a good idea to keep track of the amount your client paid. You’ll be able to easily see when the transaction is complete and if you do end up processing a partial payment, you won’t need to make any changes to your template.
- Outstanding amount. This number may be different than the total, particularly if you accept partial payments or if your business collects late fees.
- Status. This column is particularly helpful when you want to see a list of outstanding accounts. Typically, the status of a bill will either be Current or Past Due.
Customize your invoice tracker.Once you’ve got the basics covered, you can think about customizing your invoice tracker to meet your specific needs. Does it make sense for your billing to include additional information about the customer? Do you have employees who made the sale or provided the service? When it comes to tailoring your tracker template, you might consider including the following things:
- Customer contact information. You probably won’t use this for tracking purposes, but having the customer’s phone number or email address on-hand will save you the hassle of digging up their information if you need to follow up or send a reminder.
- Point of contact. If your business deals with companies rather than individuals, you’ll likely have a point of contact within that company and may want to add that person’s name to your template.
- Employee. For businesses that pay employees a commission, this column is probably a must-have. Even if your employees don’t earn a commission, it could be helpful to have an employee’s name attached to a sale, should you need any additional information.
- Reminder. On the rare occasion that you do need to send a reminder, this column is where you would record the date that you sent the reminder.
- Late fees. Depending on the payment terms for your business, late payments may incur an additional fee. Track those fees in this column.
- Past Due Age. No matter what your payment terms are, it’s a good idea to track how late an overdue payment is. If you work with a collection agency, this column is an absolute must-have, but even if you don’t, it’s an easy way to identify the clients who are habitually late payers. If a client is consistently behind, it might be time to consider breaking ties.
Send an invoice reminder.Online invoice tracking can be a big time-saver over a traditional ledger, but you’ll probably still have to do any following up manually. When you sign up for PayPal Invoicing, you’ll have the ability to send your reminders in just a few clicks; you can even schedule bills to be sent on a specific date.
With PayPal Invoicing, you'll have a dashboard where you can view the complete history of an invoice, accept payments from 200+ markets around the globe, and more. Even better, PayPal Invoicing can help you get paid faster by giving your customers an easy way to pay – even if they don’t have a PayPal account. For example, 79% of businesses using PayPal Invoicing reported that they received payment on an invoice within a week from the time the invoice is sent out.1
No matter what kind of invoice tracker you use, organization is key. You’d hate to leave money on the table because of a messy ledger. PayPal Invoicing can help you stay organized, save time, and get paid.
1Source: comScore, based on a survey of 1,226 US and Canadian small- and medium–sized business owners asked how long on average it takes to receive a payment on an invoice from the time the invoice is sent out, using their primary invoicing tool, December 2017. 320 of surveyed businesses are currently using PayPal.
Frequently asked questions.
To create an invoice:
- Go to the invoice tool on your PayPal account.  >
- Click Create invoice in the drop-down under Create.  >
- Customize your invoice and either click Send to send it right away or Save as draft.
You don’t need to do anything special to send an invoice to another country. Just create the invoice with your customer’s email address, and we’ll send it.
If your customer has a PayPal account, we’ll automatically translate the invoice and email notification in to their language. If your customer doesn’t have a PayPal account, you can specify your customer’s language by clicking your recipient’s name or email, then choose select language.
Discover More on PayPal Invoicing
Create your Invoice
Sales Invoice Template
Contractor Invoice Template
Freelancer Invoice Template
Construction Invoice Template
You'll get an email confirming that we've sent your invoices, and when you've been paid.
Simply click Create Invoice and enter each recipient’s name or email address in the "Bill to" field.
We’ll send a separate invoice to each recipient. If you include only your recipient’s name, we’ll create a payable invoice. You can then print and deliver the invoice yourself or share a link to the invoice with your customer.
Easy Invoicing with PayPal
What is an invoice?