Divvy/Export Transactions

From AYSO Wiki
Revision as of 20:21, 20 June 2022 by Mywikis (talk | contribs) (Created page with "{{Credit Card}} {{Regional Commissioner}} {{Treasurer}} {{Section Director}} {{Area Director}} Log into Divvy Click on Transactions File:Divvy-export-transactions-1.png|...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Regional Commissioner

Template:Section Director Template:Area Director

Log into Divvy

Click on Transactions

Divvy-export-transactions-1.png

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.

Divvy-export-transactions-2.png


Next, ADD FILTER

  Divvy-export-transactions-3.png

You can set Filters by many things:

·       Date Range

·       Receipt Status

·       Name

o   Customer, vender, Supplier

·       Amount

·       Completion Status

·       Budget Name

·       Card

·       NAP CODES

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.

Divvy-export-transactions-4.png

Click on CSV to create the file.

Divvy-export-transactions-5.png

It will prompt an alert message, click on Export.

Divvy-export-transactions-6.png

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

Divvy-export-transactions-7.png



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

Divvy-export-transactions-8.png

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.

Integrate Transactions to Quickbooks

See this link: https://help.getdivvy.com/en/articles/3134369-how-do-i-set-up-the-quickbooks-integration-for-my-divvy-account