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
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
