Credit card download: transaction vs posting date = reconcile problem

1

I download credit card transactions (Chase)

Posting (later) dates seem to download for some transactions. Posting dates can be zero to several days after transaction dates.

Transaction dates are shown on statement.

sample transaction - transaction shows up 4/9 in Manager, 4/6 on statement and there is a 4/8 date in the description of the transaction

Cannot reconcile to statement since some transactions do not match reconciliation dates so are outside of statement date range.

Is it possible to import the transaction dates so transactions can be reconciled to the statement?

…or is there another solution?

Hunting around for transactions is tedious. In addition to unknown dates of transaction vs posting dates, it doesn’t help that the statement shows all refunds first (for the entire statement period) and purchases second (also for the entire statement period) and the ledger in Manager is strictly by date so there isn’t a consistent flow between the two data sources.

Thanks in advance.

2

What bank statement format are you importing? Could you send me the file to lubos@manager.io ? Generally speaking, payments and receipts have fields for both transaction and posting dates so Manager should be able to import correctly.

3

emailed. included data file and screen shots

4

edited initial post to correct date terms

statement is transaction date (early date)

import is a later date (assumed to be posting date but even that seems off by a date on a sample transaction)

sample transaction - transaction shows up 4/9 in Manager, 4/6 on statement and there is a 4/8 date in the description of the transaction

5

As lubos requested, please show screenshots of the file and the results - it is not clear from your description alone where they problem lies

6

Screen shots below.

Lubos looked at the download and surprisingly the QBWebConnect QBO file from Chase has only one date and that is the posting date.

We’re looking at other formats the data is available to see which has the transaction dates. So far Excel/CSV has both dates.

More to be discovered and then I’ll need to have an efficient way to update 2,000+ transactions with the transaction date - I’m thinking of using Batch Update and figuring out how to mate Post date/Description/Amount to align with the transaction/Key of the existing transactions.

image (1)
image (1)1536×627 48.1 KB

image
image1049×688 102 KB

7

Would it make material difference to your financial statements? I don’t think so. I would just fix the dates for the transaction where it’s required for bank reconciliation purposes. And leave the rest as it is.

From now on as you will be importing transactions, they should have correct date.

2 Likes
8

this is what I discovered on Chase downloaded transactions.

only the CSV file has both the transaction date and the posted date

Card Transaction Date Post Date Description Category Type Amount Memo
2188 11/6/2024 11/8/2024 BIEN MUR TRAVEL CENTER Gas Sale -13.01
2188 11/7/2024 11/8/2024 SHIPPO.COM Office & Shipping Sale -6.98

all other download formats have only the posted date.

The statements, both in printed form and in the on-line interactive form, show the transaction date.

I’ve tested an import of the CSV into a test business and it imports with the transaction date.

Guess the lesson learned on Chase Credit Card downloads is to do it in CSV.

9

I’ve imported them already in QB format that’s want cause this issue.

I’ve had issues when trying to do band-aid fixes on compromised data so will proceed in getting it fully correct. Since I have them already in accounts and divisions I’ll see if I can bulk edit with editing the transaction date. …Will back up first

10

This illustrates both the flexibility and lack of standardization of all bank statement formats. It is really up to the financial institutions to decide what to include in each of the defined fields, whether to include anything at all in some cases, or whether to provide any uniformity amongst multiple formats offered.

All that reinforces the reality that if imports work for you, great. But if they don’t, that is the bank’s fault, not Manager’s. Remember, banks have absolutely no incentive to make statements accessible by customers function. That they provide them at all is something of a miracle and due solely to their customers’ demands. Banks derive no benefit whatsoever from providing them.

2 Likes