Export Divvy Transactions

From AYSO Wiki
Revision as of 17:37, 24 August 2022 by Paulamuesse (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Divvy provides the ability to categorize transactions within Divvy both on the web browser and in the app. Divvy has our AYSO Chart of Account (NAP codes) available to choose from when categorizing transactions. First categorize all transactions in Divvy. Then follow the steps below to export the categorized transactions. Following these steps will enable each transaction to be imported into Zipbooks or another accounting software so that double coding is not needed. Quickbooks offers an integration.

Export Divvy Transactions

  • Log into Divvy
  • Click on Transactions
  • If this is the the first time exporting transactions, add correct columns to the transaction list in Divvy. This is a one time step, then Divvy memorizes the preferred columns desired.
  • Click on the column symbol and select NAP codes and Notes in the drop down menu.
  • Next, ADD FILTER

Available filters:

  • Date Range
  • Receipt Status
  • Name
  • Customer, vender, Supplier
  • Amount
  • Completion Status
  • Budget Name
  • Card
  • Most importantly add the dates for the month of the transactions desired for export. For example 2/1/22 – 2/28/22 for all February transactions. The total should match the payment made on March 1.      
  • Prior to exporting the data, review all transactions are categorized to correct NAP codes and the status of transactions is complete.

Incomplete Transactions may be missing:            

  • Receipts, invoices, notes, and NAP Codes

To export transactions to a CSV File click on right hand side square.

Click on CSV to create the file.

It will prompt an alert message, click on Export.

Check your email. (FYI it is the same email you use to login)

Download the file. It will be in a CSV file format (similar to Excel).  

Open the downloaded file with the Divvy transactions.

If your computer has Excel installed, use Excel. If your computer does not have Excel installed, use Google Sheets. If you are using a Mac, it is suggested that you use Google Sheets or Numbers.

Save this document (for example, Feb 2022 Divvy Transactions).

Review transactions

The total value of the transactions should equal the payment that was made. For example:

Payment made January 1 is for all transactions from December 1-31st. The total payment on January 1st should equal the total of all transactions exported for the period December 1-31st. If the amounts do not tie out, then you may need to start over.

See Zipbooks Import Transactions for next steps.

For assistance: E-mail: help@getdivvy.com  Call: 385-352-0374

Chat: Chat into support via their Divvy accounts

See Also