Bulk Reconcile

[astraseske]

When using the bulk reconcile at the end of the month, it is reconciled. However, if I go to a prior date within the month, the data does not reconcile. Is that normal or does it mean that I have reconciled the wrong data?

Thanks,

Adam

[Mark]

Hi Adam,

What is not reconciled about it? Does it say the statement is missing, or did it find the statement, but some share balances are off? What specifically is the problem?

[astraseske]

First, I download three days of transactions. I bulk reconcile for the first day. In the most recent, 8 cash transactions are off by pennies. I click the back key, then go to the next date and it reconciles without me changing anything. It seems each time I download more than one days worth of transactions I see this happen and don't know if it is normal.

[Mark]

Hi Adam,

I assume you meant that 8 cash "investments" are off on their balance by pennies? When you reconcile you are comparing the share balance in an investment with the share balance being reported on the statement you are reconciling with. The share balance on any given date is the sum of all the transaction shares up through that date.

If you look at the transactions in these investments, are they all as you expect and as shown on your statements from the broker?

It may be that a later transaction file had transactions for an earlier date. For example, if you imported day 1 transactions only, and then reconciled with day 1 position file it would balance. If you then import day 2 transactions, it could have transactions for day 1, that would then cause a reconcile error if you reconciled with day 1 position file that didn't know about the day 1 transactions in the day 2 file. You might try importing 1 day at a time, and reconciling each day as you go, to figure out where this error is coming from.

Where are your transaction/position files coming from?

[astraseske]

Hi Mark,

I think I have the reconcile figured out. I am doing as you suggest and only one day at a time. It seems Schwab only goes 3 decimals on some ETF and stock transactions which throws the numbers off. I don't have nearly the problems with the TD Ameritrade downloads.

Thanks,

Adam

[Mark]

Hi Adam,

Yes, I recall this same issue with Scwab's Data Delivery data files. Their transaction files report to 3 digits, but their position files report to 4. This isn't an issue with things like stocks, but anything where you buy fractional shares it can be problematic. I believe their new data feed has fixed this issue, but FM hasn't switched over to the new format yet. Hopefully we can add support for that in the near future.