[GNC-dev] Further feedback
Christopher Lam
christopher.lck at gmail.com
Thu Feb 7 22:04:02 EST 2019
Unfortunately it's very difficult to understand the target report.
It would be much better to have a tiny test datafile - 10 amounts per
account, of various reconciliation states.
I suggest a test datafile as follows:
1. BANK
* 01-jan-19 $1.00 reconciled
* 03-jan-19 $10.00 reconciled
* 05-jan-19 $100.00 reconciled
* 10-jan-19 $1,000.00 unreconciled
* 14-jan-19 $10,000.00 reconciled
* 18-jan-19 $100,000.00 cleared
* 15-mar-19 $1,000,000.00 unreconciled (future payment)
* Last reconciled date 15-jan-2019 - reconciliation amount was $10,111.00
* Today 8-feb-2019
What should the reconciliation report header columns and contents look like?
What would be the exact process for reconciliation (on the 15th Jan)
How would the reconciliation report be useful for a user (report run
today 8-feb-2019)
On 8/2/19 6:04 am, Stephen M. Butler wrote:
> On 2/6/19 10:04 PM, Christopher Lam wrote:
>> Ok please refresh and try again.
>>
>> P.S. when all's finalised, we'd love some help in writing
>> documentation for the reconciliation report :)
> Aha! Tech writer I am not -- but I've done a bunch of it over the years
> so can lend a hand.
>
> I have attached the "current state" of the Test-Reconcile.gnucash GnC
> file. This is with transactions reconciled in the four accounts thru
> 31-Jan-2019.
>
> In the attached Reconcile-Report.html I've selected the three
> Assets:BECU:* accounts and the Liabilities:Credit Card:Citi account.
>
> Only two of those accounts have un-reconciled transactions at this time
> (Checking and Citi). I have pasted the report below.
>
> Hmm. Looks like I as wrong on the Money Market -- it is reconciled
> through 5-Feb-2019
>
> I have adjusted the summary report shown below to have the figures I
> think they should have given our requirements and the below transactions.
>
>
> Reconciliation Report
>
> Account Reconcile
> Last Date Starting
> Balance Reconciled
> Ending
> Balance Outstanding
> Current
> Balance
> Assets:BECU:Checking 01/31/2019 $25,000.00 $-10,392,15 $14,607.85
> $1829.51
> $16,427.36
> Assets:BECU:Money Market 02/05/2019 $0.00 $15,500.17 $15,500.17
> $0.00 $15,500.17
> Assets:BECU:Savings 01/31/2019 $0.00 $29.88 $29.88 $0.00 $29.88
> Liabilities:Credit Card:Citi 01/31/2019 -$430.96 $74.29 -$356.67
> $0.00 -$356.67
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Here is the transaction report for the four accounts. I tried to sort
> the secondary key on reconcile date.
>
>
> Transaction Report
>
>
> From 01/01/2019 to 12/31/2020
>
>
> Date Reconciled Date Num Description Memo/Notes Account Debit
> Credit
> Checking <gnc-register:acct-guid=e336d76c46691239a50ad9d3695b0648#>
>
> 02/05/2019
>
> Waste Connections
> Assets:BECU:Checking
> $31.49 <gnc-register:trans-guid=a6262be3d8d445be91286193f2cd6776#>
>
> 02/13/2019
>
> Other
> Assets:BECU:Checking $651.50
> <gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb#>
>
> 02/13/2019
>
> Other
> Assets:BECU:Checking $1,529.50
> <gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb#>
>
> 02/06/2019
>
> Regence
> Assets:BECU:Checking
> $165.00 <gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788#>
>
> 02/06/2019
>
> Regence
> Assets:BECU:Checking
> $165.00 <gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788#>
>
> 01/01/2019 01/01/2019
> Make It Interesting
> Assets:BECU:Checking $25,000.00
> <gnc-register:trans-guid=ea49cb4a98e2421085e66d22ede821bf#>
>
> 01/04/2019 01/31/2019
> Regence
> Assets:BECU:Checking
> $165.00 <gnc-register:trans-guid=5048bfe00fbf481e8e9fa9945cbcaf04#>
>
> 01/18/2019 01/31/2019
> Compensation
> Assets:BECU:Checking $8,158.00
> <gnc-register:trans-guid=2a1a2b8d296e405c8c94f855f96046b0#>
>
> 01/25/2019 01/31/2019
> March trip
> Assets:BECU:Checking
> $2,000.00 <gnc-register:trans-guid=071342882b2a4ad289e41cbd18102d0c#>
>
> 01/03/2019 01/31/2019
> Citi Card
> Assets:BECU:Checking
> $3,946.29 <gnc-register:trans-guid=38b549241ec84f709ef5d809d70a9e7b#>
>
> 01/10/2019 01/31/2019
> Winco
> Assets:BECU:Checking
> $3.20 <gnc-register:trans-guid=c4c855fa16c241059e24016b41f2f471#>
>
> 01/22/2019 01/31/2019 1234 DOL (utility trailer)
> Assets:BECU:Checking
> $23.75 <gnc-register:trans-guid=5f161ea8a9c043f2ae8f19a6c60bf830#>
>
> 01/25/2019 01/31/2019
> Measley
> Assets:BECU:Checking $327.93
> <gnc-register:trans-guid=6bb69e286a904740a1fb6b61be1cef50#>
>
> 01/25/2019 01/31/2019
> To MMKT
> Assets:BECU:Checking
> $15,500.00 <gnc-register:trans-guid=e137e649118942dca609c6cde2ae5c83#>
>
> 01/11/2019 01/31/2019
> Vancouver
> Assets:BECU:Checking
> $365.48 <gnc-register:trans-guid=d69f41a613bb491682efd49d2a2693c8#>
>
> 01/22/2019 01/31/2019
> Wanita Refund
> Assets:BECU:Checking $1,932.64
> <gnc-register:trans-guid=e35634a51ad04bf8adc55cb5d2f18a15#>
>
> 01/07/2019 01/31/2019
> Winco
> Assets:BECU:Checking
> $37.31 <gnc-register:trans-guid=08080f210984493b8aacd2f5c9d3264b#>
>
> 01/09/2019 01/31/2019
> Other
> Assets:BECU:Checking $651.50
> <gnc-register:trans-guid=72c6ffe83d3a4faba24cf60dbad84fca#>
>
> 01/04/2019 01/31/2019
> Dividend/Interest
> Assets:BECU:Checking $1.66
> <gnc-register:trans-guid=700ae59e3afb49d8ad858e42c0626cf7#>
>
> 01/30/2019 01/31/2019
> Closet Refund
> Assets:BECU:Checking $36.92
> <gnc-register:trans-guid=72935169739f461e87018858f8fb1404#>
>
> 01/13/2019 01/31/2019
> Winco
> Assets:BECU:Checking
> $8.81 <gnc-register:trans-guid=409980fe78bd49daa59fb52c48c3152c#>
>
> 01/28/2019 01/31/2019
> Clink
> Assets:BECU:Checking
> $53.99 <gnc-register:trans-guid=f9553d1ac45a4de888fe3930766dabbb#>
>
> 01/11/2019 01/31/2019
> IHSA
> Assets:BECU:Checking
> $56.23 <gnc-register:trans-guid=f25044e14ead44689f562245421a1557#>
>
> 01/27/2019 01/31/2019
> Winco
> Assets:BECU:Checking
> $57.44$361.49 <gnc-register:trans-guid=cebf58b2cca143a081f3ad1882201cf4#>
>
> 01/04/2019 01/31/2019
> Waste Connections
> Assets:BECU:Checking
> $31.49 <gnc-register:trans-guid=3bcda468a048438281a0201021984991#>
>
> 01/04/2019 01/31/2019
> Regence
> Assets:BECU:Checking
> $165.00 <gnc-register:trans-guid=5048bfe00fbf481e8e9fa9945cbcaf04#>
>
> 01/23/2019 01/31/2019 1235 Bambi
> Assets:BECU:Checking
> $39.00 <gnc-register:trans-guid=c1e6b104e8be4e8287475a972a68ef58#>
>
> 01/18/2019 01/31/2019
> Winco
> Assets:BECU:Checking
> $36.34 <gnc-register:trans-guid=94c1689ea0ed4e54bb785e4acad3247a#>
>
> 01/22/2019 01/31/2019
> Steve Refund
> Assets:BECU:Checking $2,032.50
> <gnc-register:trans-guid=9f84ba4ba8004c2ebd5982c864e4a7cd#>
>
> 01/09/2019 01/31/2019
> Other
> Assets:BECU:Checking $1,529.50
> <gnc-register:trans-guid=72c6ffe83d3a4faba24cf60dbad84fca#>
>
> 01/15/2019 01/31/2019 1233 Hair Perm OFX ext. info: |Trans
> type:Check Assets:BECU:Checking
> $28.00 <gnc-register:trans-guid=7cd94faa725d4c6f933287053766ac7b#>
>
> 01/22/2019 01/31/2019
> Farm
> Assets:BECU:Checking
> $952.90 <gnc-register:trans-guid=848ca984a3384801b70850ac45205754#>
>
> 01/25/2019 01/31/2019
> Umbrella
> Assets:BECU:Checking
> $1,091.00 <gnc-register:trans-guid=9d68937f60c44d41b9495aa400056911#>
>
> 01/23/2019 01/31/2019
> Clark PUD
> Assets:BECU:Checking
> $216.70 <gnc-register:trans-guid=d16b9e40628349b7a96d18e3263861ae#>
>
> 01/23/2019 01/31/2019
> Clark PUD
> Assets:BECU:Checking
> $284.87 <gnc-register:trans-guid=eeccc62590ba4630b48e336a2d1f15a8#>
>
> Total For Checking $16,427.36
> Money Market$361.49
> <gnc-register:acct-guid=de5442b1fc27101e3822bbaa4993e409#>
>
> 01/04/2019 02/05/2019
> Dividend/Interest
> Assets:BECU:Money Market $0.17
> <gnc-register:trans-guid=700ae59e3afb49d8ad858e42c0626cf7#>
>
> 01/25/2019 02/05/2019
> To MMKT
> Assets:BECU:Money Market $15,500.00
> <gnc-register:trans-guid=e137e649118942dca609c6cde2ae5c83#>
>
> Total For Money Market $15,500.17
> Savings <gnc-register:acct-guid=c031d083606552f4e97e56a6ce5daa5e#>
>
> 01/02/2019 01/31/2019
> refund for 5/13/2018
> Assets:BECU:Savings $27.49
> <gnc-register:trans-guid=c6151672897647d085cf030f79fe2530#>
>
> 01/16/2019 01/31/2019
> Dividend/Interest
> Assets:BECU:Savings $2.39
> <gnc-register:trans-guid=5291c7c162be40f0b60da4687d4a5309#>
>
> Total For Savings $29.88
> Citi <gnc-register:acct-guid=c93aeb4e48bdd6a03d27def67408db5d#>
>
> 02/05/2019
>
>
>
> Liabilities:Credit Card:Citi
> $0.00 <gnc-register:trans-guid=bf7e89f232654fc3864934f080a98d8d#>
>
> 01/07/2019 01/14/2019
> SAFEWAY #4313 BA OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $8.95 <gnc-register:trans-guid=b3c10f661e8643b2b8e95d4e495d8fff#>
>
> 01/03/2019 01/14/2019
> US Mobile 88 OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $23.53 <gnc-register:trans-guid=0ca3b0dcba4e4bb0afee07c8a7978fda#>
>
> 01/10/2019 01/14/2019
> COSTCO GAS #0772 VA OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $30.00 <gnc-register:trans-guid=a8c51b5f359a497ab1c739d3f6b54f71#>
>
> 01/07/2019 01/14/2019
> COSTCO WHSE #0772 VA OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $162.73 <gnc-register:trans-guid=2880ec8028e64e5c9750a376e026692b#>
>
> 01/07/2019 01/14/2019
> COSTCO GAS #0772 VA OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $46.30 <gnc-register:trans-guid=ebb5f116ac1d4f0a9b863d6f8b7128c4#>
>
> 01/03/2019 01/14/2019
> US Mobile 88 OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $14.15 <gnc-register:trans-guid=549506f474b540c7bf60b074477dbd0d#>
>
> 01/03/2019 01/14/2019
> US Mobile 88 OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $18.15 <gnc-register:trans-guid=8438e5f6d48542c296ffbdec36d40156#>
>
> 01/08/2019 01/14/2019
> AMZ*CANON USA, INC. am OFX ext. info: |Trans type:Generic debit
> Liabilities:Credit Card:Citi
> $127.15 <gnc-register:trans-guid=f3257dccf625499c8bbe9a6e992bda0a#>
>
> 01/08/2019 01/31/2019
> JC OFX ext. info: |Trans type:Generic debit Liabilities:Credit
> Card:Citi
> $140.00 <gnc-register:trans-guid=d5b626a84c0542f29218132113d8ed94#>
>
> 01/01/2019 01/31/2019
> More Interesting
> Liabilities:Credit Card:Citi
> $2,500.00 <gnc-register:trans-guid=b3fa0f9fb63d44ff93af719cceea905c#>
>
> 01/02/2019 01/31/2019
> RSI OFX ext. info: |Trans type:Generic debit Liabilities:Credit
> Card:Citi
> $1,200.00 <gnc-register:trans-guid=8565e8b6ca4442f0a9030c101d974177#>
>
> 01/09/2019 01/31/2019
> ENV OFX ext. info: |Trans type:Generic debit Liabilities:Credit
> Card:Citi
> $6.00 <gnc-register:trans-guid=d17dc77f78174df8b8df34094e2f01ca#>
>
> 01/09/2019 01/31/2019
> IJS OFX ext. info: |Trans type:Generic debit Liabilities:Credit
> Card:Citi
> $26.00 <gnc-register:trans-guid=9d2038a9f94d4d91a0845b17c5347feb#>
>
> 01/03/2019 01/31/2019
> Citi Card
> Liabilities:Credit Card:Citi $3,946.29
> <gnc-register:trans-guid=38b549241ec84f709ef5d809d70a9e7b#>
>
> Total For Citi
> $356.67
> ------------------------------------------------------------------------
> Grand Total $31,600.74
>
More information about the gnucash-devel
mailing list