Accounting department “wrong totals” on printed forms — step-by-step fixes

Joe B.

Expert ★★★★★ 27,853 satisfied customers

Specialities: Windows/macOS printing, Excel & PDF output, QuickBooks/ERP forms, Drivers & Fonts

Printed invoice shows incorrect total — rounding, scaling, margins, fonts, PDF export

Technician

Hey! We’ll sort out wrong totals on printed forms (invoices, statements, PO). Quick triage so we target the fix: Do the totals look correct on screen but change on paper/PDF print? Are you printing from Excel, QuickBooks, an ERP/Crystal Reports layout, or a browser form? And which printer/driver mode is used (PCL, PostScript, XPS)?

Customer

On screen the invoice total is fine. When we print from Excel and from a PDF export, some lines round differently and the grand total is off by a few cents. It started after moving to a new HP printer.

Technician

Got it. Typical causes of incorrect totals when printing are:
• Excel using full-precision math while cells are formatted to 2 decimals (“Set precision as displayed” not enabled) → printed sum differs from visually rounded values.
• Region settings (decimal/thousand separator) and currency formats mismatching the template.
• Scaling/Shrink to fit, margins, or text overflow that truncates a cell/field so the printed number is visually different.
• Font substitution (missing fonts) in PDF/driver, or PCL vs PostScript rendering differences.
• Report logic: tax/VAT/GST rounding per line vs on subtotal, hidden rows/filters excluded from the SUM, wrong print area.

Customer

We do line-item rounding to 2 decimals and then sum. Sometimes the printed copy shows 0.01 off. Also some totals clip at the edge when we fit to one page.

Technician

Step 1 — Make math and display match in Excel
1) In File → Options → Advanced enable Set precision as displayed (or explicitly ROUND: =ROUND(Amount*Qty,2) and =ROUND(SUM(range),2)). This removes hidden fractions causing rounding errors on printouts.
2) Check Number format for currency, decimal separators, and negative numbers (accounting vs currency). Align Region/locale with your template.
3) In Page Layout: set Margins (Normal), turn off Scale to Fit or use a stable percentage (100% or 95%), and ensure the Print Area and Page Breaks don’t cut totals. This prevents clipped fields and mismatched layout.

Customer

We also generate PDFs for emailing. Could the PDF driver change totals? Some PCs don’t have the corporate font.

Technician

Step 2 — Stabilize PDF output
• Export using Save as PDF with embed fonts enabled; avoid “print to PDF” if it rasterizes differently.
• If totals still look wrong when printing the PDF, in Acrobat choose Advanced → Print as Image to bypass driver math, or switch the device to PostScript/XPS driver for consistent rendering.
• Install the required company fonts (or replace with a widely available font) to prevent font substitution that can shift character widths and truncate totals.

Customer

We run invoices from QuickBooks and a Crystal Reports layout. VAT is per line; the printed grand total is occasionally off from the on-screen preview.

Technician

Step 3 — Align report logic & tax rounding
• Confirm whether VAT/GST is rounded per line or on the subtotal and make the report use the same rule as accounting.
• In Crystal/ERP fields, apply Round({field},2) for amounts and taxes before summing; ensure hidden/filtered rows aren’t excluded from totals.
• Lock the field width and enable Can Grow or “Autosize” so long amounts don’t truncate. Truncation makes the printed figure look smaller even if the math is correct.

Customer

The new HP driver has PCL6 and PS options. Which should we pick? Also we enabled “Fit to page”.

Technician

Step 4 — Choose a stable driver and disable destructive scaling
• Use the vendor’s PostScript (PS) or XPS driver for forms with tight alignment and currency columns; PCL6 is fast but can differ on text metrics.
• In the driver, set 100% scale, disable “Shrink to Fit” and edge-to-edge tricks; enforce standard non-printable margins to avoid clipped totals.
• Turn off caching features like “Send TrueType as Bitmap” only if font issues persist; otherwise keep text as text for crisp numbers.

Customer

Some users print via VPN and different region settings. Could that affect decimal separators or dates on the printout?

Technician

Yes — locale/region can alter separators and currency. Standardize with a deployment script or GPO:
• Force the template’s Locale in Excel/ERP and avoid “Use system separators” when not desired.
• For remote printing, ensure drivers match on both sides (server/client) and prefer server-side rendering or PDF to stabilize output over VPN.

Customer

We applied rounding and set scaling to 100%. PDFs now match screen and paper. Anything else to keep this from regressing?

Technician

Final checks to prevent printed totals incorrect:
• Lock formulas with ROUND() in all amount/tax cells and in the grand total.
• Save the layout with embedded fonts; keep a test PDF as the “golden sample”.
• Document driver settings (PS/XPS, 100% scale, margins). After printer swaps, re-apply the same profile.
• For QuickBooks/Crystal, store the report version in source control and avoid ad-hoc changes that break invoice totals.

Customer

Great — the totals now match across Excel, PDF, and paper. Accounting is happy. Thanks!

Technician

Summary: Fix “wrong totals” on printed accounting forms by rounding with ROUND() or enabling precision as displayed, aligning locale and currency formats, disabling destructive scaling, embedding fonts, and using a consistent PS/XPS driver or “Print as Image” for PDFs. Need help applying this across the team? Open the chat.

Quick answer: the accepted fix

Accepted fix when printed invoices show incorrect totals: round amounts and taxes with ROUND() or enable Set precision as displayed; standardize region/locale; export PDFs with embedded fonts; set printer driver to PostScript/XPS at 100% scale and normal margins; avoid “Shrink to fit”. This stabilizes Excel/QuickBooks/ERP forms so paper, PDF, and screen totals match.

FAQ

Step-by-step (Excel/Windows)

1. ROUND each calculated cell and the grand total; optionally enable precision as displayed.
2. Standardize locale and currency; confirm decimal and thousand separators.
3. Set margins and 100% scaling; verify Print Area and page breaks.
4. Export PDF with embedded fonts; print via PostScript/XPS or “Print as Image”.

Note for macOS & mixed environments

1. In Numbers/Excel for Mac, enforce the same rounding and currency formats.
2. Use the system PDF workflow with embedded fonts; avoid automatic “Scale to fit one page”.

Sources

• Microsoft — Excel ROUND function & precision
• Adobe — Print PDF as Image (driver workaround)
• Microsoft — PS vs PCL vs XPS print drivers

Matt ● replies in < 1 min

Technician Expert

⭐⭐⭐⭐⭐ Trusted by 27,000+ customers

Alex · Expert's Assistant

Start Chat

5 Tech Support Specialists are online right now.