Complete Guide to Proforma Invoices 2026: Definition, Functions, and How to Create Them

Have you ever felt stuck when an important transaction is suddenly delayed just because a customer asks for a Proforma Invoice, while you are still unsure how it differs from a regular bill?

Don't worry, this situation is very common for novice business owners. In fact, this document often serves as a "golden ticket" for buyers to process down payments (DP) or simply handle internal budget approvals before a final agreement is reached.

Let's discuss the vital functions of this document without getting trapped in confusing technical jargon. From practical definitions and mandatory 2026 standards to a step-by-step guide on creating one in Excel, we will cover everything to ensure your business operations appear more professional and your transactions run smoothly.

What Is a Proforma Invoice?

Simply put, a Proforma Invoice is a temporary billing document. If a regular invoice is considered an "official bill" requiring immediate payment, then a proforma is a "final proposal" agreed upon by both parties.

This document conveys the message: "If you proceed with buying this item, here are the details regarding the price, specifications, and total cost that must be paid later."

It is important to remember that the value stated in a Proforma Invoice is not yet legally recorded as accounts receivable or payable in accounting books. It is merely an initial agreement before the actual transaction takes place.

Key Functions for Sellers and Buyers

Why is this document so crucial? Because it bridges the negotiation process to the actual transaction. Here are its main benefits:

For the Buyer:

• Accurate Cost Estimate: Knowing the total funds that must be prepared (including tax and shipping costs) to avoid hidden fees.

• Funding Request: Serves as written proof to request payment approval from the finance department or management.

• Administrative Requirement: A mandatory document for processing import permits (Prohibitions and Restrictions/Lartas) or opening a Letter of Credit (L/C) at a bank.

For the Seller:

• Commitment Lock: Ensures the buyer's seriousness before you go through the trouble of preparing stock or shipping goods.

• Down Payment (DP) Collection: Serves as a valid basis for billing a Down Payment to secure operational cash flow before work begins.

When is the Right Time to Send It?

The best moment to send a Proforma Invoice is after price negotiations are complete, but before goods are shipped or services are performed.

Avoid sending it when goods are already in transit, as that is the function of a Commercial Invoice (Sales Invoice). Send the proforma exactly when the customer says, "Okay, I agree with the price, please send me the total details so I can process the payment."

Mandatory Components in a Proforma Invoice (2026 Standard)

Although it is "temporary" in nature, this does not mean you can scribble it on a scrap of paper. This document is a representation of your business professionalism.

To ensure it isn't rejected by a client's finance department or held up at customs (if exporting), ensure your Proforma Invoice contains the following four vital elements:

1. Seller & Buyer Identity (Header) This is the most basic section but is often written incorrectly. Ensure clarity on:

• Seller: Company logo, official name (PT/CV/Ltd/Inc), full address, and contact number.

• Buyer: The target company name or individual (Bill To).

• Tip: In 2026, including an email address and business WhatsApp number in the header has become standard to speed up communication regarding billing inquiries.

2. Specific Product or Service Description Avoid writing just "Consulting Services" or "Shoes." Write in as much detail as possible to avoid future disputes.

• Item/Service Name: E.g., "Sneakers Model X-200 (Red)".

• Quantity & Unit: Order volume along with the unit of measurement (pcs, units, kg, box).

• Price & Calculation: Price per unit and the total overall value.

3. Validity Period This is a "safety" component for the seller. Raw material prices can change at any time. Do not let your Proforma Invoice be valid forever. Include a phrase like: "Price valid until February 20, 2026" or "Valid for 14 days." If the buyer pays a month later and prices have risen, you have valid grounds to revise the price because the validity period has expired.

4. Terms of Payment Clarify the payment rules to keep your cash flow safe:

• Method: Bank Transfer (include Account No., Bank Name, and Beneficiary Name), Credit Card, or Virtual Account.

• Conditions: Is a 50% DP required first? Or Full Payment before shipment? State this clearly at the bottom of the document.

How to Create a Proforma Invoice in Microsoft Excel

You don't need to subscribe to expensive accounting software just to create this document. Microsoft Excel (or Google Sheets) is more than sufficient, provided you know how to use it correctly.

Forget physical calculators. Let's build an automated template so your work is faster and calculation errors are minimized.

1. Preparing a Simple Product "Database" A beginner's mistake is typing item names and prices manually every time a new invoice is created. This wastes time. Create a separate sheet in Excel (e.g., name it Sheet2 or "Master Data"). Create a simple table containing a list of your products/services along with their unit prices. When drafting a proforma on the main page, you simply look up or copy data from here. This ensures the pricing you provide is always consistent.

2. Using Excel Formulas for Automation Don't let your clients find addition errors! Use these basic formulas to let Excel do the hard work for you:

• Calculating Subtotal (Gross Amount): Use the SUM formula to calculate faster. Example: If the total price per row is in cells E5 to E10, type the formula: =SUM(E5:E10). Press Enter, and the total appears automatically.

• Calculating VAT (Value Added Tax/PPN): In 2026, the VAT rate in Indonesia is generally 12% (according to the HPP Law regulations). To calculate it automatically, multiply the subtotal by the tax rate. Example: If the Subtotal is in cell E11, the tax formula is: =E11*12%.

• Calculating Grand Total: Simply add the Subtotal and VAT: =E11+E12 (Assuming E12 is the result of the tax calculation above).

3. Finishing & Export to PDF (Mandatory!) This is the most important security step. Never send a raw file (.xlsx or .xls) to a customer. Raw files are very easily edited; nominal figures or your bank details could be changed without your knowledge. Always save the final document as a PDF:

• Click File > Save As (or Export).

• Select PDF format.

• Send the PDF file. This makes the document look professional and "locked," keeping it safe from external manipulation.

Legal and Tax Aspects (Indonesian Context)

Once the document is created, important questions arise: "Is this Proforma Invoice considered proof of tax withholding?" or "Must I immediately deposit VAT after sending this document?"

The answer is: NO.

In Indonesia, many novice entrepreneurs get paranoid about taxes when issuing a proforma. Let's clear up this misunderstanding based on applicable regulations.

Proforma Invoice is Not a Tax Invoice It is important to underline: A Proforma Invoice is not the same as a Tax Invoice (Faktur Pajak). From the perspective of the Directorate General of Taxes (DJP), a Proforma Invoice is merely a commercial document, not a tax document. This means the document cannot be used by the buyer (your client) to claim Input Tax Credit. An official Tax Invoice (e-Faktur) may only be—and must be—issued by you when the transaction is materially valid, not just an agreement on proforma paper.

When is VAT Actually Due? Don't rush to deposit tax just because you've sent a Proforma Invoice. According to regulations (including the legal basis of PER-03/PJ/2022 which remains the technical reference for invoicing): The obligation to create a Tax Invoice (and collect VAT) arises only when:

1. Money Comes In: When payment is received (whether partial/DP or paid in full), OR

2. Goods Go Out: When goods/services are delivered.

Whichever happens first is the trigger.

Case: You send a Proforma Invoice today, but the client pays next week. Solution: You do not need to create a Tax Invoice today. Create the Tax Invoice next week when the money enters your account.

So, a Proforma Invoice is safe to send as often as needed without burdening your tax obligations at that very moment. It is merely an "invitation" for the buyer to transfer funds immediately.

Conclusion

Creating a Proforma Invoice is not just an administrative formality, but a strategic step to secure your business cash flow. This document functions as a "safety net" ensuring both parties you and the buyer have the same understanding regarding price and product details before the transaction truly occurs.

By understanding the mandatory 2026 standards and tax aspects, you can now negotiate with more confidence without fearing missteps in legal matters.

FAQ: Frequently Asked Questions by Beginners

Here are a few brief questions to clear up common confusion:

Q: What is the difference between a Proforma Invoice and a Quotation? A: A Quotation is usually sent at the very beginning when a buyer is just "inquiring." A Proforma Invoice is sent when the buyer is 90% agreed and ready to make a payment or handle administration. The commitment level is higher.

Q: Can a buyer pay using a Proforma Invoice? A: Absolutely. That is its function! This document serves as the basis for the buyer to transfer a down payment (DP) or full settlement upfront.

Q: If the transaction is cancelled, what should I do with the Proforma Invoice that was already sent? A: You don't need to do anything. Since it hasn't been recorded as a receivable in official books, you can simply ignore it or mark it as "Void/Cancelled" in your internal records. There is no tax impact.

Hassle-Free Business Document Management Solution

Managing dozens of Proforma Invoices manually using Excel might still be effective when a business is just starting. However, as customers increase, the risk of human error—such as inputting the wrong price or forgetting an invoice sequence number will grow larger.

If your business is ready to level up, switch to an integrated system. Soltius provides world-class ERP (Enterprise Resource Planning) system solutions capable of automating the creation of Invoices, Proformas, and tax reporting in one neat dashboard.

Don't let your productive time be consumed by manual administration. Contact Soltius now for a consultation regarding the right business management system for your company's growth.