Online Banking Transactions – Samples Needed

Sorry to write again so soon, but I just realized I need more samples – particularly from American banks. If any of you could go to your online banking, and request a download to QuickBooks (if that’s an option), save the file, and email it to us, that would be great. If your bank doesn’t support downloads to QuickBooks, but does to Quicken, that would be fine too. And if doesn’t support either, please at least tell us what downloads it does support.

The downloaded files are actually plain text files, so if you want to first open them up in an editor (like Notepad) and make sure there’s nothing confidential you want to change, that would be fine.

In particular if you do a credit card statement download, your card # is in the file, in a section that may look like this:

<CCACCTFROM><ACCTID>4500xxxxxxxxxxxx<ACCTTYPE>CREDITLINE</CCACCTFROM>

For bank accounts, your account number may be in it, in the format:

<BANKACCTFROM>
<BANKID>xxxxxxxxx
<ACCTID>xxxxxxxxxxxxxxxxxxxxxxx

I changed confidential parts in the samples above to x’s. Stuff might be on separate lines, as in the 2nd example, or all on one line, as in the first example.

From Canadian banks, I already samples from have one credit union, a few online-only banks, and out of the big 5, I have TD, CIBC, RBC and BMO. If someone has Scotiabank, I would appreciate a sample. No further samples from the others are needed.

I don’t have any US bank samples yet, so anything you have would be great – please tell us what bank it is from when you send it.

Thanks so much in advance.

2 thoughts on “Online Banking Transactions – Samples Needed

  1. Hi Dan,

    Attached is our credit union’s export when I choose Quicken from their list. I edited it to remove an employee name and some bank ids.

    Credit Union: First Community Credit Union

    I hope this is helpful.

    Chuc Saint Louis Friends Meeting

    On Tue, May 8, 2018 at 2:15 PM Software4Nonprofits ACCOUNTS Blog wrote:

    > Dan Cooperstock posted: “Sorry to write again so soon, but I just realized > I need more samples – particularly from American banks. If any of you could > go to your online banking, and request a download to QuickBooks (if that’s > an option), save the file, and email it to us, that wo” >

Comments are closed.