On 2/4/19 11:56 PM, Christopher Lam wrote:
> Thanks! And a report example as well as the options to be specified too?
Before doing any reconciliation -- Pre-Reconciled.html
Reconciled Checking, Savings, Money Market, and Cit Credit card to 1/31/2019
Then produced Post-Reconciled.html
The only options picked where on the Accounts tab. Picked BECU and
Liabilities and the Children button.
Note that the Post- file doesn't show the transactions reconciled.
Should be easy to produce both based on the XML file previously
submitted. I just checked everything off for the month of January on
each reconcile action for the four accounts (I picked statement date of
1/31 to make it easy to remember). As you can see, only checking had
February transactions. And, yes, some of those are in the future!
>
>
>
> On Tue., 5 Feb. 2019, 08:54 Stephen M. Butler <kg...@arrl.net
> <mailto:kg...@arrl.net> wrote:
>
> On 2/4/19 2:56 PM, Christopher Lam wrote:
> > Thank you for detailed algorithm. I'll see about that over next
> week.
> Yup. A lot of work there.
> >
> > We may have to limit the report to one account for various reasons,
> > but will try avoid this.
> I could work with that. But a bank statement might trigger a
> reconcile
> for Checking, Saving, Money Market, Visa card (all on one
> statement).
> But it would be four different reconciliations -- all on the same day.
> >
> > If you have the time and inclination, a test datafile, with crafted
> > but realistic amounts, is very welcome. Perhaps about 10
> transactions
> > of various dates in 3 accounts, fully or partly reconciled (or
> not) in
> > the past, and example report output, will help illustrate. <--
> Welcome
> > to test-driven development.
> >
> > C
>
>
> I tried. Hope it is interesting enough. Noticed that some had
> partial
> reconciliations already done. So....
>
> All Asset accounts (low level) and all Liability accounts (lowest
> level)
> should be reconciled at some point. None have been. I removed a
> bunch
> of accounts and transactions to get here. It might not make sense (or
> cents either).
>
Reconciliation Report
Account Starting Reconciled Ending
BECU $0.00 $0.00 $0.00
Checking $14,607.85 $14,607.85 $16,427.36
Money Market $15,500.17 $15,500.17 $15,500.17
Savings $29.88 $29.88 $29.88
Liabilities $0.00 $0.00 $0.00
Credit Card $0.00 $0.00 $0.00
BECU $0.00 $0.00 $0.00
Citi -$356.67 -$356.67 -$356.67
Date Num Description Account Funds In Funds Out
[1]Checking
Unreconciled
02/04/2019 Assets:BECU:Checking [2]$0.00
02/04/2019 Assets:BECU:Checking [3]$0.00
02/05/2019 Waste Connections Assets:BECU:Checking [4]$31.49
02/06/2019 Regence Assets:BECU:Checking [5]$165.00
02/06/2019 Regence Assets:BECU:Checking [6]$165.00
02/13/2019 Other Assets:BECU:Checking [7]$1,529.50
02/13/2019 Other Assets:BECU:Checking [8]$651.50
Total For Unreconciled $2,181.00 $361.49
Total For Checking $2,181.00 $361.49
[9]Citi
Unreconciled
02/05/2019 Liabilities:Credit Card:Citi [10]$0.00
Total For Unreconciled $0.00
Total For Citi $0.00
References
1. gnc-register:acct-guid=e336d76c46691239a50ad9d3695b0648
2. gnc-register:trans-guid=71a0f316698f40b6a491fb700d26ffe9
3. gnc-register:trans-guid=22251036a9944f679c68c8b09c24f45b
4. gnc-register:trans-guid=a6262be3d8d445be91286193f2cd6776
5. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788
6. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788
7. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb
8. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb
9. gnc-register:acct-guid=c93aeb4e48bdd6a03d27def67408db5d
10. gnc-register:trans-guid=bf7e89f232654fc3864934f080a98d8d
Reconciliation Report
Account Starting Reconciled Ending
BECU $0.00 $0.00 $0.00
Checking $25,000.00 $25,000.00 $16,427.36
Money Market $0.00 $0.00 $15,500.17
Savings $0.00 $0.00 $29.88
Liabilities $0.00 $0.00 $0.00
Credit Card $0.00 $0.00 $0.00
BECU $0.00 $0.00 $0.00
Citi -$430.96 -$430.96 -$356.67
Date Num Description Account Funds In Funds Out
[1]Checking
Unreconciled
01/03/2019 Citi Card Assets:BECU:Checking [2]$3,946.29
01/04/2019 Regence Assets:BECU:Checking [3]$165.00
01/04/2019 Regence Assets:BECU:Checking [4]$165.00
01/04/2019 Waste Connections Assets:BECU:Checking [5]$31.49
01/04/2019 Dividend/Interest Assets:BECU:Checking [6]$1.66
01/07/2019 Winco Assets:BECU:Checking [7]$37.31
01/09/2019 Other Assets:BECU:Checking [8]$651.50
01/09/2019 Other Assets:BECU:Checking [9]$1,529.50
01/10/2019 Winco Assets:BECU:Checking [10]$3.20
01/11/2019 IHSA Assets:BECU:Checking [11]$56.23
01/11/2019 Vancouver Assets:BECU:Checking [12]$365.48
01/13/2019 Winco Assets:BECU:Checking [13]$8.81
01/15/2019 1233 Hair Perm Assets:BECU:Checking [14]$28.00
01/18/2019 Compensation Assets:BECU:Checking [15]$8,158.00
01/18/2019 Winco Assets:BECU:Checking [16]$36.34
01/22/2019 Farm Assets:BECU:Checking [17]$952.90
01/22/2019 Wanita Refund Assets:BECU:Checking [18]$1,932.64
01/22/2019 Steve Refund Assets:BECU:Checking [19]$2,032.50
01/22/2019 1234 DOL (utility trailer) Assets:BECU:Checking [20]$23.75
01/23/2019 Clark PUD Assets:BECU:Checking [21]$216.70
01/23/2019 Clark PUD Assets:BECU:Checking [22]$284.87
01/23/2019 1235 Bambi Assets:BECU:Checking [23]$39.00
01/25/2019 Measley Assets:BECU:Checking [24]$327.93
01/25/2019 Umbrella Assets:BECU:Checking [25]$1,091.00
01/25/2019 March trip Assets:BECU:Checking [26]$2,000.00
01/25/2019 To MMKT Assets:BECU:Checking [27]$15,500.00
01/27/2019 Winco Assets:BECU:Checking [28]$57.44
01/28/2019 Clink Assets:BECU:Checking [29]$53.99
01/30/2019 Closet Refund Assets:BECU:Checking [30]$36.92
02/04/2019 Assets:BECU:Checking [31]$0.00
02/04/2019 Assets:BECU:Checking [32]$0.00
02/05/2019 Waste Connections Assets:BECU:Checking [33]$31.49
02/06/2019 Regence Assets:BECU:Checking [34]$165.00
02/06/2019 Regence Assets:BECU:Checking [35]$165.00
02/13/2019 Other Assets:BECU:Checking [36]$1,529.50
02/13/2019 Other Assets:BECU:Checking [37]$651.50
Total For Unreconciled $16,851.65 $25,424.29
Total For Checking $16,851.65 $25,424.29
[38]Money Market
Unreconciled
01/04/2019 Dividend/Interest Assets:BECU:Money Market [39]$0.17
01/25/2019 To MMKT Assets:BECU:Money Market [40]$15,500.00
Total For Unreconciled $15,500.17
Total For Money Market $15,500.17
[41]Savings
Unreconciled
01/02/2019 refund for 5/13/2018 Assets:BECU:Savings [42]$27.49
01/16/2019 Dividend/Interest Assets:BECU:Savings [43]$2.39
Total For Unreconciled $29.88
Total For Savings $29.88
[44]Citi
Unreconciled
01/01/2019 More Interesting Liabilities:Credit Card:Citi [45]$2,500.00
01/02/2019 RSI Liabilities:Credit Card:Citi [46]$1,200.00
01/03/2019 Citi Card Liabilities:Credit Card:Citi [47]$3,946.29
01/08/2019 JC Liabilities:Credit Card:Citi [48]$140.00
01/09/2019 ENV Liabilities:Credit Card:Citi [49]$6.00
01/09/2019 IJS Liabilities:Credit Card:Citi [50]$26.00
Total For Unreconciled $3,946.29 $3,872.00
Total For Citi $3,946.29 $3,872.00
References
1. gnc-register:acct-guid=e336d76c46691239a50ad9d3695b0648
2. gnc-register:trans-guid=38b549241ec84f709ef5d809d70a9e7b
3. gnc-register:trans-guid=5048bfe00fbf481e8e9fa9945cbcaf04
4. gnc-register:trans-guid=5048bfe00fbf481e8e9fa9945cbcaf04
5. gnc-register:trans-guid=3bcda468a048438281a0201021984991
6. gnc-register:trans-guid=700ae59e3afb49d8ad858e42c0626cf7
7. gnc-register:trans-guid=08080f210984493b8aacd2f5c9d3264b
8. gnc-register:trans-guid=72c6ffe83d3a4faba24cf60dbad84fca
9. gnc-register:trans-guid=72c6ffe83d3a4faba24cf60dbad84fca
10. gnc-register:trans-guid=c4c855fa16c241059e24016b41f2f471
11. gnc-register:trans-guid=f25044e14ead44689f562245421a1557
12. gnc-register:trans-guid=d69f41a613bb491682efd49d2a2693c8
13. gnc-register:trans-guid=409980fe78bd49daa59fb52c48c3152c
14. gnc-register:trans-guid=7cd94faa725d4c6f933287053766ac7b
15. gnc-register:trans-guid=2a1a2b8d296e405c8c94f855f96046b0
16. gnc-register:trans-guid=94c1689ea0ed4e54bb785e4acad3247a
17. gnc-register:trans-guid=848ca984a3384801b70850ac45205754
18. gnc-register:trans-guid=e35634a51ad04bf8adc55cb5d2f18a15
19. gnc-register:trans-guid=9f84ba4ba8004c2ebd5982c864e4a7cd
20. gnc-register:trans-guid=5f161ea8a9c043f2ae8f19a6c60bf830
21. gnc-register:trans-guid=d16b9e40628349b7a96d18e3263861ae
22. gnc-register:trans-guid=eeccc62590ba4630b48e336a2d1f15a8
23. gnc-register:trans-guid=c1e6b104e8be4e8287475a972a68ef58
24. gnc-register:trans-guid=6bb69e286a904740a1fb6b61be1cef50
25. gnc-register:trans-guid=9d68937f60c44d41b9495aa400056911
26. gnc-register:trans-guid=071342882b2a4ad289e41cbd18102d0c
27. gnc-register:trans-guid=e137e649118942dca609c6cde2ae5c83
28. gnc-register:trans-guid=cebf58b2cca143a081f3ad1882201cf4
29. gnc-register:trans-guid=f9553d1ac45a4de888fe3930766dabbb
30. gnc-register:trans-guid=72935169739f461e87018858f8fb1404
31. gnc-register:trans-guid=71a0f316698f40b6a491fb700d26ffe9
32. gnc-register:trans-guid=22251036a9944f679c68c8b09c24f45b
33. gnc-register:trans-guid=a6262be3d8d445be91286193f2cd6776
34. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788
35. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788
36. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb
37. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb
38. gnc-register:acct-guid=de5442b1fc27101e3822bbaa4993e409
39. gnc-register:trans-guid=700ae59e3afb49d8ad858e42c0626cf7
40. gnc-register:trans-guid=e137e649118942dca609c6cde2ae5c83
41. gnc-register:acct-guid=c031d083606552f4e97e56a6ce5daa5e
42. gnc-register:trans-guid=c6151672897647d085cf030f79fe2530
43. gnc-register:trans-guid=5291c7c162be40f0b60da4687d4a5309
44. gnc-register:acct-guid=c93aeb4e48bdd6a03d27def67408db5d
45. gnc-register:trans-guid=b3fa0f9fb63d44ff93af719cceea905c
46. gnc-register:trans-guid=8565e8b6ca4442f0a9030c101d974177
47. gnc-register:trans-guid=38b549241ec84f709ef5d809d70a9e7b
48. gnc-register:trans-guid=d5b626a84c0542f29218132113d8ed94
49. gnc-register:trans-guid=d17dc77f78174df8b8df34094e2f01ca
50. gnc-register:trans-guid=9d2038a9f94d4d91a0845b17c5347feb
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
