I see what you mean now. Just to be clear, let me paraphrase: - You download a CSV or OFX file at date C - The transactions in it span dates A -> B - At the time of download, the transactions from dates B -> C haven't been included yet, but they exist (they are said to be "pending") and will later appear - Your importer inserts the balance up to B at date C. Later on, you import transactions from B -> C and the balance assertion fails. The solution is simple: Have your importer insert the balance assertion at date B + one day.
If what I describe above is not the situation you're facing, it's possible you just need to go back in time at the first failing assertion and manually inspect the list of transactions to find missing ones that you may not have recorded in your input file. As a guideline, for credit cards, I tend to use a balance assertion for every download (every week or two) and it works fine. (You can also insert balance assertions manually by logging into your online account and looking at the current balance and date.) On Mon, May 9, 2016 at 12:00 AM, Jason Chu <[email protected]> wrote: > The problem is that postings are inserted before the statement end in the > next billing cycle (because of random delays in the charge processing > systems) so the balance assertion can't be against any given date. > > On Sun, May 8, 2016 at 8:41 PM yegle <[email protected]> wrote: > >> If you have one balance assertion for each statement, you'll be able to >> reconcile each billing cycle separately. >> >> On Sun, May 8, 2016 at 2:01 PM, Jason Chu <[email protected]> wrote: >> >>> Every time I import transactions from my credit card the balance lines >>> never match up. I understand this is because transactions can be inserted >>> inserted in history. How do other people reconcile their credit card >>> statements to make sure they have the correct balance for a given set of >>> transactions? I'm afraid if I don't do this I will end up missing or >>> double counting a transaction somewhere and not accurately representing my >>> debt. >>> >>> Gnucash had a mechanism for reconciling a set of transactions with a >>> statement, where it would change the state of the transaction to reconciled >>> (y vs n or c) and would verify that all reconciled transactions at that >>> point in time matched the statement balance. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Beancount" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/beancount/2a5a65cb-ba31-4a9c-b5c8-fcbaf6fb78e7%40googlegroups.com >>> <https://groups.google.com/d/msgid/beancount/2a5a65cb-ba31-4a9c-b5c8-fcbaf6fb78e7%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Yuchen Ying >> http://about.me/yegle >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Beancount" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/beancount/CAFL5w3X9m987Dk4NO8xaxczGjJDsjt2DGOoNoBwgVGqaPJOTuA%40mail.gmail.com >> <https://groups.google.com/d/msgid/beancount/CAFL5w3X9m987Dk4NO8xaxczGjJDsjt2DGOoNoBwgVGqaPJOTuA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "Beancount" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/CAFFHUgsLVOweX-YW2A4mNTYqDipSF3zR3VKPRJd4C%2Bn9TdE27w%40mail.gmail.com > <https://groups.google.com/d/msgid/beancount/CAFFHUgsLVOweX-YW2A4mNTYqDipSF3zR3VKPRJd4C%2Bn9TdE27w%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNPQ8ynTKK%2BP_PJ3i_%2BsdQ1iLxxFJLc9nXWUjA35N8LAQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
