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
--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
Test-Reconcile.gnucash
Description: application/gnucash
Reconciliation Report Account Reconcile Last Date Starting Balance ? Ending Balance Outstanding Balance Current Balance Assets:BECU:Checking 01/31/2019 $14,607.85 $14,607.85 $14,607.85 -$361.49 $14,246.36 Assets:BECU:Money Market 02/05/2019 $15,500.17 $15,500.17 $15,500.17 $0.00 $15,500.17 Assets:BECU:Savings 01/31/2019 $29.88 $29.88 $29.88 $0.00 $29.88 Liabilities:Credit Card:Citi 01/31/2019 -$356.67 -$356.67 -$356.67 $0.00 -$356.67 Date Num Description Account Funds In Funds Out [1]Checking Unreconciled 02/05/2019 Waste Connections Assets:BECU:Checking [2]$31.49 02/06/2019 Regence Assets:BECU:Checking [3]$165.00 02/06/2019 Regence Assets:BECU:Checking [4]$165.00 02/13/2019 Other Assets:BECU:Checking [5]$1,529.50 02/13/2019 Other Assets:BECU:Checking [6]$651.50 Total For Unreconciled $2,181.00 $361.49 Total For Checking $2,181.00 $361.49 [7]Citi Unreconciled 02/05/2019 Liabilities:Credit Card:Citi [8]$0.00 Total For Unreconciled $0.00 Total For Citi $0.00 References 1. gnc-register:acct-guid=e336d76c46691239a50ad9d3695b0648 2. gnc-register:trans-guid=a6262be3d8d445be91286193f2cd6776 3. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788 4. gnc-register:trans-guid=eda6189be5194add8a1f351a79f5c788 5. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb 6. gnc-register:trans-guid=23fdbd177eec4eb7a7f182f0cdfe28cb 7. gnc-register:acct-guid=c93aeb4e48bdd6a03d27def67408db5d 8. gnc-register:trans-guid=bf7e89f232654fc3864934f080a98d8d
_______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
