[GNC-dev] Further feedback

Stephen M. Butler kg7je at arrl.net
Tue Feb 5 12:13:37 EST 2019


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 <kg7je at arrl.net
> <mailto:kg7je at 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).
>

-------------- next part --------------
  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
-------------- next part --------------
  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


More information about the gnucash-devel mailing list