POPROOF / TESTING GUIDE
From a supplier invoice to the right costs, payment and credit
POProof checks each supplier invoice against the purchase order you approved, then helps you act on it: update Shopify's cost per item from the invoice, track what to pay and the credits owed, and export the bill to QuickBooks Online or Xero. All samples below are fictional. Open POProof from Shopify Admin; there is no separate POProof login or external account for reviewers. Catalog refresh is optional. Use a fresh development store so the free checks and test billing start from zero.
Plans
Plans are chosen on Shopify's own plan page: Manage plan on Home and Check invoice, and every Upgrade button, open it. On a development store, choose Basic or Pro with Shopify test billing; no card or external payment account is needed.
| Plan | What it includes |
|---|---|
| Free (no plan) | 3 invoice checks a month (checking the same invoice again is free), uploads, the Shopify purchase order picker, Excel/CSV/print reports and the cost update preview. |
| Basic, USD 19/month | Unlimited checks, cost updates written to Shopify, invoice status and credit requests, and exports, including bills for QuickBooks Online and Xero. |
| Pro, USD 49/month | Everything in Basic, plus the invoice email inbox, automatic checks when stock arrives, price history and price-rise alerts, the margin check and the supplier scorecard. |
1. Quickest look: sample data
On Home, select Try it with sample data. POProof runs the bundled sample PO and invoice below and opens a page labelled Sample data: USD 80.00 of findings, a read-only cost update preview with made-up products, the invoice status and amount to pay, the credit request email, and example price-rise and supplier numbers. It works on any plan, uses no free check and isn't counted anywhere. Remove sample data deletes it in one click.
2. Download a matching pair
Download all sample files and this guide
| Format | Purchase order | Supplier invoice |
|---|---|---|
| CSV | po-1001.csv | invoice-1001.csv |
| XLSX | po-1001.xlsx | invoice-1001.xlsx |
| Digital PDF | po-1001.pdf | invoice-1001.pdf |
Each format contains the same four source items. CSV and XLSX do not use PDF extraction. PDF extraction is configured by POProof; no reviewer API key is needed. These files use made-up SKUs, so they can't change costs in your store; section 8 tests cost updates with your own products, using Make a sample invoice from this PO.
3. Main test: enter these exact values
| Supplier | Demo Wholesale |
|---|---|
| PO reference | PO-1001 |
| Invoice reference | INV-1001 |
| PO currency / invoice currency | USD / USD |
| Is this the only invoice for this PO? | Yes (a complete invoice) |
| Invoice subtotal / total | Leave blank for the first test. Both are 300.00 if you want to check the declared amounts. |
- In Shopify Admin, open Apps > POProof > Check invoice.
- Enter the values above, keep Upload a PO file, select the purchase-order file and invoice file, then click Read files.
- Inspect both source tables (four rows each) in step 2, Check columns. Under Which column holds each value, check Quantity (required) → Quantity, Unit price (required) → Unit Price, SKU → SKU, Description → Description, and invoice Line total → Line Total. Leave Barcode unmapped if no barcode column exists.
- If an extracted cell differs from the original, correct it in the preview. Use numbers such as
1234.50. For a summary row that is not an item or a separate invoice charge, select Exclude. Review every page if the document has more than ten rows. - Click Run audit. The result must appear below the form as step 3, Review results, and be saved in Recent checks. On Free it says how many free checks are left this month (for example This used free check 1 of 3 this month. 2 left.).
PDF preview: POProof may preselect Exclude for purchase-order rows labeled Freight, Tax, or Discount when they contain only a line total and no SKU, barcode, quantity, or unit price. Review those selections against the original PO and clear Exclude if a row belongs in the check. Keep separate invoice charges included. Numeric cells may carry a currency symbol or code, thousands commas and bracket negatives (USD 0.00 is read as 0.00). Only a value that could be read two ways, such as a decimal comma, stops the audit for correction.
4. Verify the result
| Item | Expected finding | Potential overcharge |
|---|---|---|
| A100 | 10 at 5.00 matches the PO | 0.00 |
| B200 | Invoice quantity 6; PO quantity 5 | 20.00 |
| C300 | 20 units at 4.00; PO price 3.50 | 10.00 |
| X999 | Unexpected item absent from the PO | 50.00 |
| D400 | Missing from this complete invoice | Not added to overcharge |
| Total | Potential amount to review before payment | USD 80.00 |
The results screen shows the findings heading 4 findings: $80.00 to dispute, 1 missing item, then each finding in plain words with its amount (money findings first), a Next: line with Request the credit, and the Line details table. Click Download Excel report and open the file. The Report tab lists the same findings in the same order with an Amount column; Line details shows quantities, prices, units, and source-row references. Downloading a report uses the completed check and does not use another free check.
Download CSV includes invoice and PO values, currency, references, each line's finding and amount, and missing items. Print report opens a print-ready copy of the results. Run the same documents again: the saved check is updated without using another free check.
The paired .xlsx and digital .pdf files contain the same values; rerun them with the same references and check PDF extraction against the original documents before accepting the result.
5. Test recovery
- After Read files, change A100's invoice Unit Price cell to
5,00(a decimal comma) and run. A row-specific error should appear (Supplier invoice row 2: the unit price "5,00" uses a comma as the decimal point…) while the source rows, entries, and mappings stay in place. - Correct it to
5.00and run again. The check should complete without reselecting files. - Replace either uploaded file. The previous preview must be cleared and Run audit unavailable until Read files runs again.
- Clearing or excluding every mapped line must produce an error, not a successful zero-dollar audit.
6. Partial invoices and other scenarios
For the free-check demonstration, run the main test and then the two regular partial invoices: that uses this month's three free checks. Run the other scenarios after test billing is active (section 7). Clear optional invoice subtotal/total whenever switching sample scenarios.
| Scenario | Files and values | Expected result |
|---|---|---|
| Partial billing | partial PO, then 40-unit invoice and 60-unit invoice. Supplier Partial Demo Supplier; PO reference PO-PARTIAL-1; invoice references INV-PARTIAL-1 and INV-PARTIAL-2; USD; Is this the only invoice for this PO? set to No, there will be more (partial). | First check bills 40 of 100. Second shows 40 billed earlier on the PO line and bills the remaining 60 without a quantity error. |
| Partial overbilling | Use separate supplier Overbilling Demo Supplier, PO-PARTIAL-1, USD / USD, No, there will be more, and blank optional subtotal/total. Pair partial PO with the 40-unit invoice as INV-PARTIAL-1, then the 70-unit invoice as INV-PARTIAL-OVER. Do not reuse the supplier whose PO was already fully billed by 40 + 60. | 40 billed earlier plus 70 now exceeds 100 by 10 units at USD 5.00: USD 50.00 potential overcharge. |
| Clean invoice | PO + clean invoice. Use separate supplier Clean Demo Supplier, PO-1001, INV-CLEAN-1, USD / USD, Yes (complete), and blank optional subtotal/total. | USD 0.00; no discrepancies. Keeping Demo Wholesale from the main test would count its earlier billed quantities. |
| Remembered pack mapping | PO + pack invoice. Use supplier Mapping Demo Supplier, PO-1001, INV-MAPPING-1, USD, Yes (complete). Select Fix this match on CASE-A100, choose PO SKU A100 and PO units per invoice unit 10, select Remember match, then Run audit again. | One USD 50.00 case matches ten USD 5.00 units; potential overcharge becomes USD 0.00. The mapping is remembered for this supplier and the report shows the multiplier. |
| Conflicting product identifiers | PO + identity invoice. Use separate supplier Identity Review Demo, PO-1001, INV-IDENTITY-1, USD / USD, Yes (complete), and blank optional subtotal/total. Leave Barcode unmapped. Confirm the fictional source pair, remember OTHER-A100 as A100 with PO units per invoice unit 1, then rerun. | Before confirmation: Needs review, Conflicting product identifiers, and A100 not invoiced. The unresolved row is excluded from overcharge and prior billed quantities; USD 0.00 does not mean a clean invoice. After confirmation: all four items match; USD 0.00, with no unresolved lines. Check the warning in the CSV export too. |
| Currency mismatch | Use the main pair with PO currency USD and invoice currency EUR. | A clear currency warning. No monetary comparison or conversion. |
7. Free checks and upgrading
- Free: after the main test and the two regular partial invoices, all three free checks are used. A box headed This month’s 3 free checks are used, with an Upgrade to Basic ($19/month) button, appears at the top of the upload step; the form stays usable. Checking a saved invoice again stays free. A new fourth invoice shows the upgrade message on Run audit. Review cost updates still shows the preview, with an Upgrade to Basic button in place of Update cost per item. Invoice status, Invoices, Prices, Suppliers and Inbox each explain their plan and link to Shopify's plan page.
- Basic: select Manage plan, approve Basic with test billing and return to POProof. A new check runs with no free-check line. Update cost per item, invoice status, Invoices and bill export open; Prices, Suppliers and Inbox still show the Pro explanation.
- Pro: change the plan to Pro. Prices, Suppliers (with exports) and Inbox open.
- Back to Free: cancel the plan. The next new invoice uses a free check if any are left this month, otherwise it asks to upgrade, and the paid pages show their explanation again at once.
8. Cost updates with your own products (Basic)
- In Shopify Admin, create a purchase order (Products > Purchase orders) for two or three of your products, each with a cost and at least 2 units on one line. Mark it as ordered.
- In POProof > Check invoice, enter a supplier name, choose Use a Shopify purchase order, allow access when Shopify asks, and pick that PO.
- Under the picker, select Make a sample invoice from this PO. It downloads
sample-invoice-<PO>.csvwith the PO's own SKUs and quantities, one price 5% higher and one line 1 unit short; the page says which. It is built from the PO only and uses no free check. - Enter an invoice reference such as
SAMPLE-1, upload that file as the invoice, select Read files, then Run audit. Step 2 shows the Shopify PO's lines read-only, with Received beside Ordered. Expect a price finding on the raised line (the 5% difference times its quantity) and a quantity finding on the short line. If some of the PO was already received in Shopify, units billed but not received yet are shown as an amount to hold. - Select Review cost updates. Rows are ticked for you where the invoice cost per unit can be taken as it is: lines with no finding, the raised line (labelled Price went up … vs PO) and lines with units not received yet. The short line has a quantity finding and stays unticked until you tick it. Check the preview (current cost → new cost per item; on Pro also the margin before → after), select Update cost per item, then Yes, update N costs. Shopify's cost per item changes only for the ticked products.
- After the update each product is listed with its previous → new cost and a Put back button that restores just that product; Undo this update restores them all. Cost updates in the app menu lists every update, with Undo and Put back.
Apart from cost updates you confirm, POProof does not write products, orders, purchase orders, inventory, or payments to Shopify.
9. Invoice status and credit request (Basic)
- Open the main test's saved check: Invoice status and credit request or Request the credit under the results, or its invoice reference on Invoices.
- Invoice status shows the amount to pay: USD 300.00 invoiced less USD 80.00 disputed, USD 220.00. Set a due date and select Save status.
- Under Request a credit, the B200, C300 and X999 lines are ticked. Edit the email if you like, select Copy email (or Open in your mail app), then Record credit request ($80.00). POProof never sends email itself.
- Open Credit arrived?, enter the amount and date received and select Mark credit received: the amount to pay then takes off the credit received. Invoices lists every checked invoice with filters and Export CSV; credits marked received show as money recovered.
10. Bill export (Basic)
On Invoices, open Export bills for QuickBooks Online or Xero (or Export as a bill for QuickBooks Online or Xero on a saved check). Choose QuickBooks Online or Xero, optionally tick Reduce by credits received, and select Download QuickBooks CSV (or Download Xero CSV). It is a file to import as supplier bills; POProof doesn't connect to either product and changes nothing in Shopify. QuickBooks limits Bill no. to 21 characters (the sample invoice numbers are well under it).
11. Inbox (Pro)
- Automatic checks when stock arrives need no setup: on Inbox, tick Check invoices automatically when stock arrives and approve Shopify's permission prompt. Receive stock on the Shopify purchase order from section 8: the Activity list shows what is still billed but not received, or that everything billed has arrived.
- Invoice email address: the address (
invoices+…@the inbox domain) appears under Invoice email address once the inbox email domain is configured on the server. If the page says Invoice email isn't available yet, email is not switched on for this release; the rest of the Inbox page works, and invoices can be uploaded on Check invoice. - With the address: select Get my address and email a small CSV invoice (for example the sample invoice from section 8, with the PO name such as
#PO1in the subject) from your own address. It arrives as From a new sender; select Trust this sender and it is read, matched to the PO and checked.
File requirements
CSV: comma, semicolon or tab separated (detected automatically), UTF-8 or Windows encoding, with unique column headers. Numbers may include a currency symbol or code, thousands commas, and brackets or a minus sign for negatives; decimal commas such as 5,00 are rejected rather than guessed. CSV and XLSX default to headers on row 1; XLSX defaults to the first worksheet. If a file starts with title rows or uses another worksheet, open More options, enter the header row and (for XLSX) exact worksheet name, then preview again. Every populated column must have a header. Quote CSV values that contain commas. PDF: use a clean digital document with legible line items; review the extracted values. PDF extraction ignores spreadsheet layout settings. Limit each file to 20 MB, 500 line items, and 100 columns. The preview may ask for a smaller file if extracted data is too large.
For unclear PDF extraction, the same commercial data can be uploaded as CSV or XLSX. This does not replace the PDF-format test when evaluating PDF support.