Re: Help with adjustment transaction
On Fri, May 17, 2024 at 08:48:04AM +0200, Alan Schmitt wrote: > > 2023/06/30 * Balance Assertion: AccountName > > Assets:Bank:AccountName $ 0.00 = $ 52,289.96 > > This looks very useful, but I have trouble understanding how it works > with past transactions that are not yet reconciled (i.e., not part of > the balance, yet present and before in the file). Are these transactions > ignored? If so, the balance will break once they are reconciled in the > future, won’t it? TL;DR: you insert balance assertions when you know the balance based on some source of truth. My ideal workflow: - enter transactions, w/ uncleared and/or pending states. - get the latest bank statement - add assertions based on bank statement as part of the work to reconcile the statement vs the ledger. - If needed (rare), use intermediate accounts to represent uncleared funds. This should only happen if you've made a payment in such a way that the bank statement doesn't reflect it yet. The only times for Gentoo had previously been cheques that the recipient had deposited yet; and those transactions can be moved later to reflect the fact that the recipient didn't deposit the cheque for a long time. My practical workflow: - I enter data primarily from the bank & paypal transactions in the first place, and reconcile vs other sources. -- Robin Hugh Johnson Gentoo Linux: Dev, Infra Lead, Foundation President & Treasurer E-Mail : robb...@gentoo.org GnuPG FP : 11ACBA4F 4778E3F6 E4EDF38E B27B944E 34884E85 GnuPG FP : 7D0B3CEB E9B85B1F 825BCECF EE05E6F6 A48F6136 -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/robbat2-20240517T233242-785749295Z%40orbis-terrarum.net.
Re: Help with adjustment transaction
On Fri, May 17, 2024 at 06:55:12AM -0700, oliver wrote: > I am afraid you are crediting me with more intelligence than I actually > have. > I find balance assertion to be very difficult to understand and the few > lines in the docs don't make it > any easier. > Follwoing your example, I enter: > > 2024/04/08 * Balance Assertion:Ally_Savings > Assets:Ally_Savings $0.00 = $47.19 > ($47.19 being the ending balance in the account as of April 8). > > In return I get: > Warning: "home/oliver/ledger.dat", line 1003: Unknown account > 'Assets:Ally_Savings $0.00 = $47.19' > > Obviously, I am doing something wrong, but what? You need more whitespace. - An account name on the entry line must be prefixed with at least one space. - An account name must end with two or more spaces, or one or more tabs. Per the docs: | There must be at least two spaces, or a tab, between the amount and the | account. If you do not have adequate separation between the amount and the | account Ledger will give an error and stop calculating. So easy fix for you: 2024/04/08 * Balance Assertion:Ally_Savings Assets:Ally_Savings$0.00 = $47.19 -- Robin Hugh Johnson Gentoo Linux: Dev, Infra Lead, Foundation President & Treasurer E-Mail : robb...@gentoo.org GnuPG FP : 11ACBA4F 4778E3F6 E4EDF38E B27B944E 34884E85 GnuPG FP : 7D0B3CEB E9B85B1F 825BCECF EE05E6F6 A48F6136 -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/robbat2-20240517T232604-542031603Z%40orbis-terrarum.net.
Re: Help with adjustment transaction
I am afraid you are crediting me with more intelligence than I actually have. I find balance assertion to be very difficult to understand and the few lines in the docs don't make it any easier. Follwoing your example, I enter: 2024/04/08 * Balance Assertion:Ally_Savings Assets:Ally_Savings $0.00 = $47.19 ($47.19 being the ending balance in the account as of April 8). In return I get: Warning: "home/oliver/ledger.dat", line 1003: Unknown account 'Assets:Ally_Savings $0.00 = $47.19' Obviously, I am doing something wrong, but what? Thanks On Friday, May 17, 2024 at 2:48:09 AM UTC-4 Alan Schmitt wrote: > Hello, > > On 2024-05-16 22:57, "Robin H. Johnson" writes: > > > Our bank statements give us the opening and closing balances for each > > statement, and I enter those as an assertion of the balance. > > > > If I have an error somewhere before that, such as a missing transaction, > > or a typo; the assertion flags that something is wrong. > > > > If your bank statements provide a known balance after each transaction, > > you can enter that: > > > > 2009/04/30 * Interest Earned: AccountName > > Assets:Bank:AccountName $ 16.14 = $ 19,016.25 > > Income:Interest:AccountName > > > > If your bank statements provide an opening or closing balance to the > statement, > > you can use that: > > > > 2023/06/30 * Balance Assertion: AccountName > > Assets:Bank:AccountName $ 0.00 = $ 52,289.96 > > This looks very useful, but I have trouble understanding how it works > with past transactions that are not yet reconciled (i.e., not part of > the balance, yet present and before in the file). Are these transactions > ignored? If so, the balance will break once they are reconciled in the > future, won’t it? > > Best, > > Alan > -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/82706c5f-823a-4013-bc7c-c8e248aba99fn%40googlegroups.com.