bank statement import question

We cannot use payment assistant and was wondering if we can import our bank statement and use AI to populate and match debits and credits to start the bank reconciliation process. Is that something anyone has done?

Answers

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    If you bank has a supported file, they brought forth the function called clear transactions electronically. Here is what shows in the help for FENXT including the files accepted in step 2 :


    1. From the bank account record, under Register, select Clear electronically.
    2. Upload the .qif, .ofx, .qbo, bai.txt, or .qfx file from your bank.
    3. Under Set cleared date, select whether you want to use a date from the bank file for the clear date or you can specify the date.
    4. Select Clear transactions. The process begins to import the transactions and attempts to match them with transactions in the register in Financial Edge NXT.
    5. After the process completes, select the notification in the top right corner to review the Clear Transactions Electronically report displays with these important details.
      • Number of matches — Number of matched transactions with a Cleared status.
      • Total of matches — Total amount of Cleared transactions.
      • Number of exceptions — Number of unmatched transactions.
      • Total of exceptions — Total amount of unmatched transactions.
    6. Use the report to identify, match, and clear unmatched transactions. You can then reconcile the bank account. For more details, see Finalize Reconciliation.
  • Kevin, thank you for response. I will see what file extension our bank provides. Are you available for any help with this?

Categories