On Sunday, August 20, 2017 at 7:18:15 PM UTC+2, Taylor R Campbell wrote: > > > Date: Sat, 19 Aug 2017 11:07:35 -0700 (PDT) > > From: Paul Jewell <[email protected] <javascript:>> > > > > However, I have a challenge which I am hoping someone can help me with. > I > > have an account in the UK, and also one in Brussels. I transfer funds > from > > one to the other (via Transferwise), and enter a transaction such as: > > > > 2017/07/07 Funds Transfer > > Assets:ING:Current Account -1000 EUR > > Assets:Lloyds:Current Account 850 GBP > > > > The problem I have is the clearing date on the statements is different > for > > the two banks. Is there anyway I can have a different date against each > > line? > > Another way to approach this is to never write transactions that touch > the externally managed accounts, except for ones automatically > generated by a CSV or QFX import from the financial institution. > > Instead, in your ledger, identify the transfers with separate accounts > (e.g., by a txn id in the receipt that will appear in the statement), > and write down the date when you initiate the transfer: > > account Assets:Lloyds:Transfers:0123456789 > account Liabilities:ING:Transfers:9876543210 > 2017/07/07 Funds transfer > Assets:Lloyds:Transfer:0123456789 850 GBP > Liabilities:ING:Transfer:9876543210 -1000 EUR > > Then you ingest the ING statement into a transaction acknowledging > receipt of the funds: > > 2017/07/14 Lloyd's statement > Liabilities:ING:Transfer:9876543210 1000 EUR = 0 EUR > Assets:ING:Current Account -1000 EUR > > And likewise the Lloyd's statement: > > 2017/07/12 Lloyd's statement > Assets:Lloyds:Current Account 850 GBP > Assets:Lloyds:Transfer:0123456789 -850 GBP = 0 GBP > > This lets you also quickly find the outstanding transfers that have > yet to be acknowledged by the financial institutions just by examining > `ledger balance :transfer:'. > > A similar approach to recording cheques and payments is described > here: > > https://mumble.net/~campbell/2017/02/26/ledger/HOWTO-reconcile-cheques > https://mumble.net/~campbell/2017/02/26/ledger/HOWTO-reconcile-payments
Thanks Taylor - Another approach. I will have a look through your links as well - I am always interested to see how others have used ledger to solve problems! -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
