Hello,

I have been trying to set up Adagio Bank Rec for my office, and I'm having a bit of trouble with the importing statements feature. I correctly set up the fields so all the numbers are coming over in the correct field, but I'm having trouble with the transction type. I have a list of bank codes that the banks use for the type of transactions, and I spoke to a woman from Signature Bank who said I need to map out the transaction codes in the Bank Rec software. Everytime I tried to pull those numbers in from the .csv file, every single number is coming in positive regardless if its a payment or a deposit. My question is how would I go about inputting these bank codes so that the software will recognize which transaction is which? Thanks a lot!

Adam

Hi Adam,

Can we assume from your description of the CSV file received from the bank that all of the records have a positive amount? And that what you would like to do is differentiate the deposits from the payments?

Is there a field/column in your CSV file that contains some sort of transaction type, like D/P for Deposit/Payment, or C/D for Credit/Debit, or something else. If all amounts are indeed positive in the CSV file, Adagio BankRec would need some distinguishing field in the file to separate the payments from the deposits.

In the Bank Statement import template, there are a few pre-defined ways of separating payments and deposits:
- There are 2 columns for debits and credits in the file, and each transaction has a value for one and 0.00 for the other. Assign the Debit and Credit fields in the Adagio import template.
- There is an amount field in the file that is positive for deposits and negative for payments. Assign the Amount field in the Adagio import template.
- There is an amount field in the file that is always positive, and a second identifying field that is 0 for a debit and 1 for a credit. Assign Amount to the amount and Amount Type to that second field.
- There is an amount field in your file that is always positive and a second field that has D, Deb or Debit for debits and C, Cred or Credit for credits. Assign Amount to the amount field and Transaction Type for that second field.

If your bank CSV file does not match one of the above 4 scenarios, can you indicate how a record is identified as a payment or a deposit?

The .CSV files that I download do not match any of those scenarios. The amounts in the file are always positive, and the column right next to it has these 3 digit bank codes that identify which kind of transaction it is...the woman I spoke to from the bank that creates these .CSV files said that I have to somehow input these transaction codes into Bank Rec, she just doesnt know how.

OK - it sounds like your bank has managed to dream up yet another form for sending transactions. Before proceeding further, do they offer any other formats, perhaps one for downloading into QuickBooks? QuickBooks uses a format called "OFX" which Adagio also supports.

Would it be possible for you to send us a copy of the file the bank sends you, and any documentation they have provided on all the different codes? You can e-mail the files to me (abates (at) softrak.com).

I can definately send you the files...the other files they offer are .QIF files for Quicken(?) and Microsoft Money. Does Adagio support that type of file too?

Well, you might try selecting either and choosing the "OFX" type in Adagio. Who knows?