[GNC-dev] Further feedback

Thu Feb 7 17:04:58 EST 2019

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.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Test-Reconcile.gnucash
Type: application/x-gnucash
Size: 11559 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20190207/bbe1b740/attachment.bin>
-------------- next part --------------
  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