Model payments data from payment-service-provider recon data in CiviCRM into format for export into Sage Intacct
The inputs to our model that will be in CiviCRM are here:
[[ https://docs.gr4vy.com/guides/dashboard/reports/settlement/specification | Gr4vy specs ]]
In [[ https://docs.google.com/spreadsheets/d/1gs59xp1aBlo_NjZOx4AhZCdI-fi6Ym3_KQYcDfQOMo8/edit?gid=868399988 | spreadsheet form ]]
Desired output to Sage Intacct: [[ https://docs.google.com/spreadsheets/d/1P0ogOc1wKILlbbKQQsp_lkD9Du-_MoO8/edit?gid=1857897357#gid=1857897357 | requirements ]]
We will need some sort of vendor ID
Timestamp may need to be truncated to date
Any time zone is fine
May need to filter transactions based on record type
We'll need an endowment-based file uploaded separately from an annual-fund upload (filter on gift type)
May want to wait to send file to Intacct only of donations that have been confirmed from processor because of potential spoof or unfinished donations. Would mean a lag, but less thrashy.
Related files in Google Drive [[ https://drive.google.com/drive/u/0/folders/1RyqCML6TrFOF5xPHv5VSEasun4QCR5HR | Sage Intacct Integration folder ]]
[[ https://docs.google.com/spreadsheets/d/1P0ogOc1wKILlbbKQQsp_lkD9Du-_MoO8/edit?gid=1857897357#gid=1857897357 | Sample Intacct upload ]]
[[ https://docs.google.com/spreadsheets/d/1Ty1hvguhEPjyT9zCluIsXr1Zn47GPTav/edit?gid=193830238#gid=193830238 | General ledger mapping for checks ]]