An Excel payment request is a spreadsheet you use to tell a customer or client what they owe, why they owe it, when payment is due, and how to pay. Excel can calculate the amount and help you track whether it has been paid, but it does not send or process the payment; you must deliver the request and arrange payment through a separate method.
What “payment request” means in Excel
The phrase can refer to a simple request form, an invoice-style document, or a log used internally to monitor money owed. Excel can support all three. For a customer-facing request, the spreadsheet usually works like an invoice: it identifies the seller and customer, describes the goods or services, lists charges, and states the due date and payment instructions.
A payment request is not necessarily the same thing as a formal invoice. Businesses may use “invoice” for a document that follows their accounting process, while a payment request can be a less formal reminder or request for a deposit. The distinction depends on the organization and the transaction. If a contract, employer, customer, or local rule requires specific invoice details, follow those requirements rather than assuming a generic spreadsheet is sufficient.
Excel is useful when you need a flexible document, have a manageable number of requests, or want to calculate line items yourself. It is not a payment gateway: putting a bank account, payment link, or QR code on a sheet does not make Excel collect or verify funds.
Information to include
A clear request helps the recipient identify the charge and act without having to ask for missing details. Include the information that applies to your transaction, and avoid adding sensitive details that the recipient does not need.
- Sender and recipient: your business or name and contact information, plus the customer’s name or organization.
- Reference and dates: a unique request or invoice number, issue date, and due date. Use a consistent numbering system so you can match the request to later records.
- Itemized charges: descriptions, quantities, rates, and line totals. For a deposit or fixed-fee job, label the charge plainly rather than inventing line items.
- Amounts: subtotal, any applicable tax or other charge, total due, payments already received, and remaining balance where relevant.
- Payment instructions: accepted methods, a payment link or other safe directions, and any relevant reference the payer should include.
- Terms and contact: when payment is expected and whom to contact about a discrepancy. State late-payment terms only if they genuinely apply and have been confirmed.
Keep descriptions specific enough to make the request understandable, such as “Website design, milestone 2” rather than just “Services.” Do not put full card numbers, security codes, passwords, or other payment credentials in a workbook.
Build a basic request in Excel
In Excel for Microsoft 365 on Windows, start a blank workbook and arrange the page so the recipient can scan it quickly. Put your sender details and the request number near the top, followed by the recipient, issue date, and due date. Below that, create a charge table with columns for item or service, description, quantity, rate, and line amount. Reserve a small summary area for subtotal, tax if applicable, total, amount paid, and balance.
For example, a freelance designer might list two hours of revisions at $35 per hour, one hosting setup at $45, and a delivery charge of $30. The request should also identify the project and the customer. If the customer has already paid a deposit, show it as a payment received or credit and calculate the amount still due; do not present the full project total as if it remains unpaid.
Enter labels and amounts in separate cells rather than combining several values in one text cell. This makes calculations and later edits easier. Use a clear date format and a consistent currency format, and distinguish editable inputs from calculated cells—for example, by using a light fill for input cells and a separate style for totals.
Calculate line items, tax, and balance
Formulas reduce arithmetic mistakes, but they depend on a consistent cell layout. In the example below, enter descriptions in column A, quantities in C, rates in D, and line amounts in E. Use rows 11 through 13 for three charges. For the first row, with quantity 2 in C11 and rate 35 in D11, enter =C11*D11 in E11. The result is $70. Copy the formula down through E13; for the example charges, the three line amounts are $70, $45, and $30.
With line amounts in E11:E13, enter =SUM(E11:E13) in E14 for the subtotal. The example returns $145. If tax applies, put the applicable rate in D15 as a percentage—for example, 8%—and, with the subtotal in E14, calculate tax in E15 using =E14*D15. The example returns $11.60. Tax rules and rates vary; this is only an arithmetic illustration, not tax advice. Confirm the correct treatment with a qualified professional or relevant authority.
With the subtotal in E14 and tax in E15, enter =E14+E15 in E16 for the total, which is $156.60 in this example. If the amount already paid is entered manually in E17 as $50, and the total is in E16, enter =E16-E17 in E18 to show the remaining balance: $106.60. Make sure the payment amount is entered as a number, not as text, or the subtraction may not work as intended.
These formulas do not determine whether a charge or tax is appropriate; they only calculate the values supplied. If you add more charge rows, update the subtotal range so it includes them. Before sending, compare the displayed total and balance with the underlying entries.
Format the sheet for reading and printing
A request should be easy to read on screen and on paper. Give the document a descriptive heading, use bold styling for column labels and the balance due, and keep the number of colors and fonts modest. Format rates and totals as currency, quantities as ordinary numbers, and dates consistently. Avoid merged cells inside the charge table, since they can make sorting and editing less convenient.
Check the print layout before sending a file intended for printing. In Excel for Windows, use File > Print to preview the pages and adjust orientation, margins, or scaling if columns are cut off. A one-page layout can be convenient, but scaling text down until it is hard to read defeats the purpose. Excel for Mac has similar print-preview and page-layout controls, though the exact ribbon arrangement can differ.
Consider protecting formula cells from accidental edits if the workbook will be reused, while leaving the intended input cells editable. Protection can prevent some ordinary changes, but it is not a substitute for secure file sharing or encryption and should not be treated as a way to protect confidential information.
Send the request and keep a record
For a recipient who only needs to read or print the request, a PDF is often less prone to accidental edits than an Excel workbook. In Excel for Microsoft 365 on Windows, use File > Export > Create PDF/XPS to create a PDF, then check the exported pages before sharing. The recipient can review the amount without changing your formulas. If the recipient needs to edit or enter information, share the workbook only when that is appropriate.
Use a payment method agreed with the recipient, such as a payment service link or the organization’s normal payment instructions. Check that a link is correct before sending it. When providing bank details, use a suitable secure channel and verify any change to payment instructions through a separate trusted contact method; unexpected changes can be a sign of payment fraud.
Keep a copy of the sent request and record its status in a separate tracking sheet or in dedicated columns, such as request number, customer, issue date, due date, total, amount received, balance, and status. Update the record when money actually clears according to your normal process, not merely when someone says they sent it. Store records only as long as needed for your business and recordkeeping obligations.
Common problems and practical checks
- The balance looks wrong: check that the payment received is subtracted once, that the total includes the intended rows, and that number cells are not stored as text.
- A copied formula misses a charge: inspect the subtotal range after adding rows. A formula that sums E11:E13 will not include a new line entered in E14 unless the layout and formula are adjusted.
- The PDF cuts off a column: use Print preview, change the page orientation or margins, or revise column widths. Confirm that the final file remains readable.
- The customer cannot identify the request: include a unique reference and enough detail about the service, project, or purchase to connect it to the agreement.
- The spreadsheet has different totals on different devices: check formulas, manual overrides, and whether someone edited a calculated cell. Retain the original sent copy as a reference.
Before sending, verify the recipient, reference number, due date, currency, arithmetic, payment instructions, and exported document. A second review is especially useful when the request includes tax, a deposit, a discount, or multiple partial payments.
When Excel is a good fit—and when it is not
Excel can be a practical choice for occasional requests, custom calculations, or a small operation that already maintains spreadsheet records. It gives you control over layout and lets you adapt a sheet to project stages, deposits, or internal approval steps. A reusable template can save time, provided you check that old customer details and amounts have been cleared before creating a new copy.
Dedicated invoicing or accounting software may be a better fit when you need automated reminders, payment collection, recurring invoices, customer records, audit trails, or integration with bookkeeping. Such services can have fees and different features, so compare their terms and security practices. A spreadsheet can calculate an amount, but it does not automatically confirm a transfer, reconcile transactions, or maintain a complete accounting history.
Frequently Asked Questions
Can Excel send a payment request or collect money?
Excel can create and calculate a request, but it does not itself send a bill or process funds. You can share a PDF or workbook and include payment instructions or a link from a separate payment provider.
Is an Excel payment request the same as an invoice?
It can be formatted as an invoice, but the terms are not always interchangeable. Whether it meets your business, customer, or local requirements depends on the transaction and applicable rules.
Can I make a payment request in Excel for free?
If you already have access to Excel, you can build a basic request without buying a separate invoice template. Excel licensing, payment-provider charges, and any professional services you use may have separate costs.
Should I send the Excel file or a PDF?
Send a PDF when the recipient only needs to view or print the request, because its displayed layout is less likely to be changed accidentally. Send an editable workbook only when editing is needed and appropriate.
How do I show a partial payment?
List the full total, record the amount received separately, and show the remaining balance as total minus payments received. Make clear which payment has been credited and update the record when your normal process confirms receipt.
Can I use Excel to calculate sales tax?
Excel can multiply a subtotal by a rate you enter, but it cannot decide which rate or tax treatment applies to a particular sale. Verify the applicable requirements with a qualified professional or relevant authority.
Related
- Excel Max Absolute Value: Find the Largest Magnitude
- Excel Mini Calendar and Date Picker: Your Options
- Excel Min Sec Format: Display Minutes and Seconds
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Use Styles from Another Word Document in WordTo use styles from another Word document, copy them with Word’s Organizer, then apply the imported styles to…
- Circular References in Excel: How to Find and Trace ThemTo view a circular reference in Excel for Microsoft 365 on Windows, open the workbook and select Formulas…
- How to Insert a Line Break in Microsoft Word: Quick StepsTo insert a line break in Microsoft Word without starting a new paragraph, place the cursor where the…
- Google Sheets: How to Add Up a Column of NumbersIf your numbers are in B2:B10, enter =SUM(B2:B10) in an empty cell to add them; Google Sheets displays…
- Google Sheets IMPORTRANGE From the Same Sheet?No: IMPORTRANGE is intended to bring cells into a Google Sheets file from a different spreadsheet file. To…
- Excel Solver Add-In: How It Works and How to Use ItExcel Solver is an optimization add-in that finds values for selected cells to maximize, minimize, or reach a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.