Export Wave invoices and payment details to Google Sheets

To review Wave invoices in Google Sheets, use Wave Connect and choose Download in the Sheets Extensions menu. Select invoice data and include the fields you need, such as payment details or line items. This gives a finance team a spreadsheet it can use to match customer remittances to Wave invoices.
Upload a case

Key facts

Use Wave Connect in Google Sheets to download invoice data for the selected business. Choose the invoice fields and include payment details or line items for your review.

Connect Wave to Google Sheets

In Wave, open the business name menu and select Integrations. Choose Add to Sheets next to Google Sheets and install Wave Connect. In a spreadsheet, go to Extensions > Wave Connect > Connect Wave Account. Select Connect Account, check the email for the intended Wave account, and approve access when prompted. Return to the spreadsheet to close the connection window. Wave’s setup guide

Choose the invoice fields and download

  1. In the spreadsheet, go to Extensions > Wave Connect > Download. Choose the invoice data type.
  2. Use the Business dropdown in the sidebar to select the Wave business whose invoices you need.
  3. Apply available invoice filters and select the fields you need. Include payment details to review payments, or line items to investigate which goods or services an invoice covers.
  4. Click Download. Compare a few invoices in the sheet with the corresponding records in Wave before you rely on it.

For example, a wholesale distributor asks a supplier to explain why $500 is still due on invoice WS-672. The supplier downloads invoice and payment details and sees the $2,000 invoice has a $1,500 payment. The finance team confirms those figures in Wave, then uses them to ask the distributor about the remaining $500. If the customer questions a specific charge, the team can include line items in a second export.

Get the individual invoice PDF when needed

If the customer needs a copy of the invoice itself, open it in Wave and choose More Actions > Export as PDF, then Download PDF. Use the spreadsheet for reviewing invoice data and the PDF when accounts payable asks for the invoice to enter or attach to its records. Wave’s invoice PDF instructions

See Upload and download data with Wave Connect.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.