Skip to main content
G
GrasonSoftware
December 19, 2021
Question

How can I create a Bank Downloads Transaction Listing?

  • December 19, 2021
  • 1 reply
  • 0 views

I'm looking to create a listing, or an Excel export, of the Bank download Transactions we need to research.

 

Does anyone know of a way to either create a report in QBDT to print this list or to export to Excel?

Or,
Does anyone know of a 3rd party Extension which can product this list?

 

The workaround we've been using is a bit tedious and involves manually categorizing all the transactions needing further review to accounts name Unknown Deposits or Unknown Expenses, and then exporting the lists to Excel.

 

It's double-work, but at least its better than nothing.

 

I look forward to your suggestions


Mike

Grason Software & Systems Inc

 

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
December 19, 2021

Do you need to export bank transaction data to XLS as follows?

 

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500Account1

 

G
GrasonSoftwareAuthor
December 19, 2021

Fiat Lux, Thank you for the response.

 

In answer to your question, we need to export these items so that we can research them OFFLINE.

 

Also, in your example, you have assumed that all records coming into the Bank Downloads are "complete" and fully formed. One of my CPA's and I are working today and both have seen that the name CHASE MEMBER SERVICES was transmitted and received as ASE MEMBER SERVICES and CITGO MEMBERS was transmitted and received as TGO MEMBERS.

 

So, because downloads -- from banks, merchant sites or other sources -- are never 100% "accurate" we need to hold thr transaction for further investigation. That's just plain good processing and prevents
mistakes from finding their ways into corporate books.

 

Do you see the request, now?

 

Regards,

 

Mike

Terms & ConditionsAccessibility statement