Question headings reproduce wording observed in Google’s People also ask results on October 4, 2026. The answers and practical checklists are written by PBW. Search results vary by time and location.
Overdue invoice reminder emails
How to write an email for an overdue invoice?
State the invoice number, original due date, and remaining balance. Attach the invoice or provide its usual payment link. Ask the billing contact for a specific payment date, and offer to resolve missing approval details. Check recent receipts before sending so you do not chase money already received.
How do I write a friendly reminder email about a past due invoice?
Use a calm subject line such as “Payment date for invoice 1042.” Explain that your records show an open balance and ask when payment will be made. Avoid blame. Invite the customer to share a payment reference if they have already paid, then record the reply and next action.
Try this in your business
- Verify the open balance and due date.
- Ask for a payment date or the missing approval detail.
- Record the reply and your next follow-up.
Following up on unpaid invoices
How do you politely remind an unpaid invoice?
Check that the invoice reached the correct billing contact and that its balance is still open. Send a short reminder referencing the original due date. Ask whether payment is scheduled or approval information is missing. Keep a dated note of the response so your next message addresses the actual obstacle.
How do I inquire about an unpaid invoice?
Contact the person responsible for payment, identify the invoice, and ask what is preventing approval or when payment is expected. If the reply is vague, request a concrete date or the next approval step. Assign an owner to follow up and check receipts before contacting the customer again.
Excel invoice trackers
How can I create an invoice tracker in Excel?
Create one row per invoice with its number, customer, due date, amount, receipts, approved credits, and open balance. Add the billing contact, last follow-up, promised payment date, owner, and next action. Use clear headers and filters. Test partial payments and duplicate invoice numbers before relying on the totals.
What is the best way to track invoices effectively?
Use one maintained source of truth for balances, then attach a dated follow-up record to each invoice. Reconcile receipts before reviewing what is overdue. Make payment promises and unresolved disputes visible. The best setup is one your team can update reliably, whether that is accounting software or a controlled spreadsheet.
How to create an Excel spreadsheet for invoices?
Decide whether you need to produce invoices or track invoices already issued. For tracking, use a table with unique invoice IDs, real dates, and separate amount, payment, and credit columns. Calculate the remaining balance and protect formula cells. Keep a blank template separate from the working file and back it up.
Try this in your business
- Give every invoice a unique ID.
- Keep payments and approved credits separate.
- Record the owner and next follow-up date.
- Reconcile before reviewing overdue balances.
Accounts receivable aging
How to calculate aging of accounts receivable?
For each invoice with an open balance, compare the agreed due date with the review date. Group overdue balances into defined bands, such as 1–30, 31–60, 61–90, and over 90 days. Keep not-yet-due invoices separate. Reconcile receipts and approved credits before totaling the bands so the report reflects current balances.
How to create an accounts receivable spreadsheet in Excel?
Start with invoice-level records, including due dates and remaining balances. Choose one review-date cell for the report, calculate days overdue, and assign each open invoice to an aging band. Sum balances by band rather than counting invoices alone. Do not mix currencies, and investigate missing dates or negative balances before using the report.
How to write an aging formula in Excel?
For a simple example, put the review date in B1 and an invoice due date in C2, then use =MAX(0,$B$1-C2) for days overdue. This assumes valid Excel dates and an unpaid invoice. Check blank dates and settled balances separately. The zero result includes both future due dates and invoices due today.
Try this in your business
- Set a review date.
- Update receipts and approved credits.
- Group only open balances into the aging bands.
- Check payment promises as well as invoice age.
Reminders before the due date
How to ask for payment before due date?
Send a courtesy reminder that preserves the agreed deadline. Identify the invoice, balance, and due date, then provide the usual payment instructions. Ask whether the customer needs anything to approve payment on time. Do not describe the invoice as overdue or demand earlier payment unless both parties have agreed to it.
What is a good reminder message to make a payment?
A useful message says which invoice is due, how much remains, and the agreed payment date. For example: “Invoice 1042 for $600 is due Friday. Please let me know if anything is missing for approval.” Adapt the details to your records and give the customer a simple way to reply.
Second payment reminders
How to write a 2nd reminder email?
Refer to your earlier reminder and restate the verified balance. Ask for a specific payment date or the reason payment is on hold. Attach the invoice again if useful. Keep the tone professional, and set your own next review date. A second message should seek a concrete response rather than simply repeat the first.
What is a good message to send a client for a payment reminder?
Try: “Following up on invoice 1042, with $600 still outstanding. Could you confirm the payment date or tell me what is needed for approval?” Add the original due date and your usual payment instructions. Check recent receipts first, then record any promised date and the next follow-up in your invoice tracker.
Partial payments and balance updates
How do I ask for a partial payment?
State the open balance and propose a specific installment amount and date for discussion. Ask the customer to confirm any arrangement in writing, including when the remainder is due. A partial payment does not automatically settle the invoice. Record actual receipts separately from promises, and check whether the proposed arrangement fits your agreement.
How do I politely ask for an update on payment?
Acknowledge any amount already received, state the remaining balance, and ask when the rest will be paid. For example: “Thank you for the $300 payment. Could you confirm the date for the remaining $1,200?” Update your records first. If the customer identifies a dispute, assign someone to resolve that issue.
Invoice disputes and supporting records
How to professionally dispute an invoice?
Identify the invoice and the specific charge you question. Explain the discrepancy factually and attach relevant records, then ask the supplier to review it. Keep a written record of the response. If you are the supplier receiving a dispute, assign a reviewer and a response date rather than sending unchanged reminders.
What is the format of an invoice tracker?
Use a table with one row per invoice and separate fields for identity, dates, amounts, payment status, and follow-up. Add a linked dispute record when needed, showing the issue, evidence, owner, and review date. Do not subtract a disputed amount automatically; distinguish an unresolved claim from an approved credit or adjustment.
Purchase orders and invoice approval
What happens if a PO does not match an invoice?
The customer may hold payment while its team checks the discrepancy. Compare the purchase order with the invoice for service description, quantities, prices, and reference numbers. Ask the approval contact what needs correction. Preserve the original records and document an authorized correction instead of creating another unexplained invoice for the same work.
How long does a client have to pay an invoice?
Start with the payment terms agreed in your contract or order, rather than assuming a universal deadline. Confirm that the invoice and required approval details were delivered correctly. Applicable rules can also matter. If the terms are unclear or disputed, seek qualified advice before imposing fees or taking formal collection action.
Invoices a customer says are already paid
Does invoice mean you're already paid?
No. An invoice normally records an amount requested for goods or services; it is not by itself proof that the money was received. Check the payment status and supporting receipt or bank record. When a customer says it is paid, request the date, amount, and payment reference so you can reconcile it.
What do you call an invoice that has already been paid?
It is commonly called a paid or settled invoice once the full balance has been reconciled. A payment receipt is a separate record confirming receipt of funds. If only part was received, label the invoice partially paid and show what remains. Keep the original invoice number so the records stay connected.
What happens if a company pays an invoice twice?
Reconcile both receipts against the invoice and flag the apparent overpayment. Contact the customer through a verified channel to agree how to resolve it. Do not quietly treat it as earned revenue or send money to new banking instructions without verification. Have the responsible accounting person document any refund or authorized credit.
Invoice payments and approved credits
How to keep track of invoices and payments in Excel?
Use a unique invoice ID to connect each receipt to the correct invoice. Keep invoice amounts, actual payments, and approved credits in separate fields, then calculate the remaining balance. Record receipt dates and references. Reconcile to your accounting or bank records regularly, and investigate overpayments instead of hiding them in the formula.
How do you credit an invoice?
Document the approved adjustment and reference the original invoice, including the amount and reason. Follow your accounting system's credit-note or adjustment process so the original transaction remains traceable. In a manual tracker, reduce the balance only after authorization. A customer's disputed amount is not automatically a credit; ask your accountant about accounting treatment.
Duplicate invoice checks
How do you handle duplicate invoices?
Check whether the records are copies of the same invoice or separate legitimate charges. Compare invoice numbers, supplier or customer, dates, amounts, and supporting work. Flag the duplicate for review before payment or collection. Preserve the audit trail and use your system's correction process rather than deleting evidence of what happened.
How to check duplicate invoices?
Start by checking repeated invoice IDs for the same business relationship, then look for matching amounts and dates under different IDs. In Excel, conditional formatting or a helper count can highlight candidates. Review the supporting documents before treating a match as a duplicate. Recurring monthly charges can share an amount without being duplicates.
Manual tracking versus invoicing software
What is the best software for tracking invoices?
Choose based on your invoice volume, payment methods, need for automatic reminders, and existing accounting setup. Check whether the system records partial receipts, disputes, and follow-up ownership. A maintained spreadsheet can suit a small workload; software becomes more useful when manual reconciliation and duplicated entry consume time or create errors.
What are the disadvantages of manual accounting?
Manual records depend on timely entry and careful reconciliation. Duplicated data, missed receipts, inconsistent formulas, and unclear file ownership can produce unreliable balances. A spreadsheet tracker also does not automatically process payments or send reminders. Set review controls, protect formulas, and move to suitable software when the workload exceeds those controls.
Missed payment promises
How do I write an email about an overdue payment?
Reference the verified invoice balance and the payment date the customer previously confirmed. Explain that your records do not yet show the receipt. Ask whether payment was sent or whether the date has changed. Request a payment reference if appropriate, then record the response and your next review date.
How to write an email for missing payment?
First check your bank and accounting records so a delayed allocation is not mistaken for a missing payment. Identify the invoice and the expected payment date in your message. Ask the customer to confirm the transfer details or provide a revised date. Avoid accusing them of breaking a promise before checking.
Weekly receivables reviews
How to make a schedule of accounts receivable?
List each customer invoice with its issue date, agreed due date, original amount, receipts, credits and remaining balance. Choose a review date and group open amounts by age. Add the contact, payment promise and next action. Reconcile the schedule to your accounting records before using it to plan follow-up.
What are some KPIs for accounts receivable?
Useful measures include total open balances, overdue balances by age, days sales outstanding and the share of payment promises met. Choose measures your records support consistently. Review the underlying disputes and large invoices alongside the totals; a single percentage can hide an important customer problem or a recording error.
Try this in your business
- Reconcile receipts before sending reminders.
- Check promises that fell due this week.
- Assign an owner and next action to unresolved invoices.
- Review changes in overdue balances.
Billing discrepancies and corrections
What do you do if you find a billing discrepancy in an invoice?
Compare the invoice with the agreed order, delivered work and payment records. Record the disputed item and ask the responsible person to verify it. If a correction is needed, follow your accounting process and preserve the original reference. Confirm the corrected balance with the customer before restarting payment follow-up.
What happens if an invoice is incorrect?
An incorrect invoice may delay approval or cause a customer to dispute payment. Investigate the error, document the correction and send clear replacement or adjustment information through your normal accounting process. Do not silently change records after payment. Ask your accountant about required correction documents where tax rules or local requirements apply.
Asking for a payment date
How do I politely and professionally ask a client for payment?
Use a factual request with the invoice number, verified balance and agreed due date. Ask when payment will be made and whether anything is missing for approval. Keep the message short enough to answer easily. Offer the usual payment instructions without changing agreed terms or introducing unapproved fees.
How do I ask for a payment date?
Ask a direct question: “Could you confirm the date payment for invoice 1042 will be sent?” If the customer cannot commit yet, ask which approval step remains and when they can provide an update. Record the date, contact and next action rather than treating “soon” as a payment promise.
How to ask a customer for an overdue payment?
Confirm that the invoice is overdue under the agreed terms and that no receipt or approved credit has been missed. Contact the billing person with the invoice details and request a payment date. Invite them to identify a dispute or approval hold. Use their answer to choose the next follow-up.
Outstanding balance statements
How do I write an email about an outstanding payment?
Attach or reference a current statement that lists the open invoices, due dates and remaining amounts. Explain the total without confusing it with the original invoice values. Ask the customer to confirm any missing payments or disputed items. Agree on the next action and keep a dated copy of the response.
How to tell customer to pay their outstanding balance?
State what your reconciled records show and request a concrete payment date. If several invoices are open, include an itemized statement so the customer can identify each amount. Ask whether any invoice is blocked by an issue. Separate an agreed payment plan from an informal promise, and document any authorized changes.
How do you respond to an outstanding payment email?
Check the invoice and your payment records before replying. If you have paid, provide the date and appropriate reference without sending unnecessary banking information. If you dispute an amount, identify the specific item. If payment is pending, give a realistic date or explain when you can confirm one.
Invoice follow-up calls
How to politely follow up on an invoice?
Start by confirming you have reached the person who handles the invoice. State the number, balance and due date, then ask whether payment is scheduled or an approval issue remains. Listen before proposing the next step. End by confirming who will act and when, and record those details immediately.
What is a good example of a follow-up payment message?
For example: “I am checking the status of invoice 1042, with $600 outstanding. Could you confirm the payment date or tell me what is needed for approval?” Replace every detail with checked records. Add the agreed due date and a reply contact, then note the response in your tracker.
How do you politely remind someone to pay an invoice?
Keep the reminder tied to a specific invoice and avoid assumptions about the reason for delay. Explain the open amount and original due date. Ask for a payment date or the missing information needed to approve it. Check receipts before sending and use a consistent contact so customers receive coherent follow-up.
Final payment reminders
What is the best way to write a final reminder for an overdue payment?
Summarize the invoice, verified balance and earlier contact attempts. Request a response by a clear date and describe only the next step your business has authorized and can lawfully take. Do not invent penalties or threaten legal action automatically. Have the owner review disputed or consequential cases before sending.
How do I send a final reminder email?
Before sending, review receipts, disputes and previous promises. Use a clear subject line and identify the invoice and requested response date. Keep the language factual and give a contact for resolving an issue. Retain the message and any reply. A “final” label does not itself establish legal collection rights.
Invoice approval checks
What are the steps involved in the invoice approval process?
A practical workflow is to receive the invoice, check the order and delivery evidence, resolve differences, obtain the authorized approval and schedule payment. Keep a record of who approved which amount. Your customer may use a different workflow, so ask for their billing contact and required references before issuing invoices.
What are the 5 most important things to put on an invoice?
For a practical starting checklist, include the supplier and customer identities, a unique invoice number, a description of the work, the amounts due and clear payment terms. These five groups are not a universal legal list. Tax details and other required fields depend on your location and transaction.
What are the best practices for approval of billing?
Match billing to the agreed work, use an authorized approver and retain the supporting evidence. Separate disputed items from accepted amounts and resolve inconsistencies before scheduling payment. Avoid shared approvals with no named owner. For your own invoices, learn the customer’s approval route so missing paperwork does not become an avoidable delay.
Invoice follow-up procedures
How do I follow up on an outstanding invoice?
Use a repeatable routine: reconcile receipts, verify the billing contact, review the last reply and send the appropriate reminder. Request a specific date or clarification of the blocker. Assign the next follow-up to a named person. Keep disputes visible so an assistant does not chase an amount under active review.
What should I include in a follow-up email after sending an invoice?
Include the invoice number, current balance, agreed due date and a simple status question. Provide the invoice or usual payment instructions if needed. Reference any earlier promise accurately and invite the customer to explain missing approval information. Avoid including sensitive bank details unnecessarily or changing the terms in a reminder.
How do I follow up on an invoice payment?
Review the invoice’s current state before choosing a message. A future-due invoice needs a courtesy reminder, a disputed invoice needs resolution and a missed promise needs a revised date. Contact the responsible billing person, record the result and set the next review. Do not send the same generic message to every situation.
Prioritizing overdue invoices
How do you typically follow up on overdue invoices?
Start with reconciled records, then review large balances, older invoices, missed promises and unresolved disputes. Contact the appropriate billing person and ask for a specific next step. Keep a dated record and a follow-up owner. Prioritization should reflect the actual obstacle, not only the invoice’s age or the customer’s size.
How to handle overdue invoices?
Confirm the balance and agreed deadline, check whether a dispute or approval hold exists and request a payment date from the responsible contact. Track the reply and review it when due. Escalate unresolved cases to the owner. Obtain qualified advice before using collection measures, penalties or service restrictions with legal consequences.
Organizing invoice records
How to handle unpaid invoices?
Keep a reliable record of the invoice, agreed terms, delivery evidence, receipts and communications. Confirm whether the amount is not yet due, overdue or disputed. Use a dated follow-up action for open balances and reconcile before contacting the customer. Ask your accountant about accounting treatment rather than deleting unpaid invoices from records.
How to keep track of paid invoices?
Link each receipt to the correct invoice and preserve the payment date, amount and reference. Mark an invoice settled only when the remaining balance is zero after authorized adjustments. Keep paid records accessible for reconciliation, but separate them from the active follow-up list. Check partial payments rather than relying on a paid/unpaid label alone.
How to follow up on unpaid invoices?
Find the correct billing contact, confirm the current balance and ask when payment is expected or what is blocking approval. Record the reply alongside the invoice instead of relying on memory. Give each next action an owner and date. Before the next reminder, check for payments, credits and changes in the dispute status.
Choosing invoice payment terms
What are common payment terms for invoices?
Common arrangements include payment on receipt, payment in advance, milestone payments and a stated number of days after invoicing, such as net 30. Choose terms appropriate to the work and customer, and agree them before delivery. The invoice should reflect that agreement; a new deadline printed afterward may not change existing obligations.
What payment terms to put on an invoice?
State the agreed due date or payment period, currency and accepted payment method. Include any approved deposit or milestone arrangement so the balance is understandable. Describe fees or discounts only when properly agreed and applicable. For unusual terms, get accounting or legal advice before relying on standard wording copied from another business.
What are the different types of payment terms?
Payment terms can require advance payment, a deposit followed by a balance, payment at milestones, payment on delivery or payment within an agreed period. They may also specify discounts or other conditions. Compare the effect on your cash needs and customer approval process, then document the chosen terms before work begins.
Put the answers to work
Start with two free reminder email templates, or read our overdue-invoice follow-up routine. The paid toolkit provides a manual Excel tracker for up to 200 USD invoices, eight emails and a PDF playbook. It does not send reminders or synchronize with accounting software.
Sources and scope
PBW’s examples and suggested routines are practical starting points, not mandatory standards. This information is educational, not legal, tax, accounting, employment, or regulatory advice. Adapt it to your business and get qualified help for consequential decisions.