Blackbaud Accounts Payable Importing

Ask the community
1

Hi! Reaching out to see if there are any users who use Blackbaud and import using the Accounts Payable module? We would like to see how you created your import file within Ramp so that it uploads correctly into Blackbaud.

2

We use FE, but we don’t import into AP module, just straight to the GL. You currently can’t export Vendor ID from the Bill Pay area, so even if you created an export file, you would have to do a vlookup or something to get the IDs populated to import into FE. Our external Accounting team was fine to just import to the GL, but I wanted to import the bills to have the invoice history live there as well.

1 Like
3

Hi Giselle, I just did this at the request of our accounting firm as they were having a time reconciling with journal entries.

You will need to export from the Bill Pay area to get invoice and payment information, the Accounting exports do not have include it. It requires a lot of copy/paste and some VLOOKUPs. Since FE imports on IDs, I did a VLOOKUP for Vendor ID and Expense Account, and I just manually entered our AP Accounts.

If you have more than one line item on an invoice, you will need to copy and paste each line item across on single row for it to pull into the same invoice in FE, I had to do like 20 items across for one :neutral_face:.

I imported as bank drafts since Ramp pulls everything out ACH and the date is predictable. I used the payment received dates, and just update any check payments to match the ACH payments. We have all payments scheduled for Fridays and they typically withdrawal on Mondays.

Here are sample files, one is my export from Ramp Bill Pay, the other my FE import file. The headers in the FE file should map to a new import template. It should also ignore the “status” and “vendor” columns in the file and fill out the rest. I kept for record as some payments were still listed as initiated at the time of import.
Ramp Export sample.csv (571 Bytes)
FE Import Sample file.csv (14.6 KB)

Please feel free to email me if you have any questions and I can do my best to help [email protected].

Thankfully we are switching to QBO soon and will only have another 2 months of this!

1 Like