130 likes | 309 Views
PayPal Payment Importing. Steps to Importing Paypal Payments. Configure Paypal for exporting Export payments Import into QuickBase Assign/Check Imports. Configure Paypal. Get to Section for Downloading History. When login, you’ll be placed on the main homepage.
E N D
Steps to Importing Paypal Payments • Configure Paypal for exporting • Export payments • Import into QuickBase • Assign/Check Imports
Get to Section for Downloading History • When login, you’ll be placed on the main homepage. • From that screen, select the “History” menu… • select the “Download History” menu Item
Customize Downloaded Fields • When select “Download History”, you’ll get to page below. • Select the “Customize Download Fields” link…
Select appropriate fields for downloading • When select “Customize Download Fields”, you’ll get to page • Select the “Item Title” and “Custom Number” fields… • …and then hit “Save”
Download your Transactions • When select “Save”, you’ll return to the download page • Configure the download… • Select “Last Download to Present” option • Select “Comma Delimited” option for the file type • Click on “Download History” button • When prompted, select “Save” and place file in place will find it.
Invoke Import Script • Invoke the Import Script by Clicking here… • https://www.quickbase.com/db/bcat8evic?a=dbpage&pagename=importFromPayPal.html • The script will prompt for you to select the file you just saved and want to import. Browse for it and click on “Next” button • Once you hit next, the script will start processing all payments…
Assigning Unmatched Charges (if necessary) • If there are any payments that the script couldn’t match, you’ll get the following… • And QuickBase will redirect you to following screen: • Fill in the “Alumni ID” field for each unmatched payment and hit “Save and Done”
Checkout payments • Validate payment information is correct • Run “Payments Posted Today” report • https://www.quickbase.com/db/bcat8evic?a=q&qid=32 …validate all payments are allocated correctly • Allocate payments across years/projects • Run “Grid Edit of Payments I Entered Today” report • https://www.quickbase.com/db/bcat8evic?a=q&qid=104 …allocate payments across years and projects