#] 
#] *********************
#] "$d_Qndfs"'bank statements instructions.txt'  - 
# www.BillHowell.ca  26Sep2022 initial 
# view in text editor, using constant-width font (eg courier), tabWidth = 3


see also "$d_Midas"'Investments/0_banking notes.link.txt' : 
	"$d_PROJECTS"'Investments/0_banking notes.txt'				- chronoList of banking problems, actions etc
	"$d_Qndfs"'bank statements instructions.txt'					- instructions to process downloads
	"$d_Qndfs"'bank statements reformat.ndf'						- QNial coding
	"$d_Midas"'Investments/0_account macro system notes.txt'	- instructions for macro scripts, usage notes
	"$d_SysMaint"'LibreOffice/1_LibreOffice macros.txt'		- macro scripts for bank statements (not used?)
#48************************************************48




#24************************24
# Table of Contents, generate with :
# $ grep  "^#]"  "$d_Qndfs"'bank statements notes.txt' |  sed "s/^#\]/  /" 
#


#24************************24
#] Instructions

29Aug2022DO NOT USE sheet macros!!!  macro update of SB [chq, visa] codes
Tools -> macro -> crashed again (twice today!!) DON'T "run macro" -> instead "Manage macros"
use "Howell_extract_code()"

08********08
#] Step 0 - update the date range used in filenames below :  
	eg '01May2021-29Aug2022' to '08Aug2022-02Nov2022'

08********08
#] Step 1 - download all data to text files!! 

+--+
Interac to HSBC most of chequing 7 k$
Electronic transfer limit What is my electronic transfer limit?
$3,000.00 daily / $10,000.00 weekly 

08********08


TD statements update
View last xx days 
Date - reverse this column, oldest -> newest
bottom of transaction listing : spreadsheet (CSV) format
	/run/media/bill/Midas/Investments/TD Canada Trust/TD_statement_cheq raw.txt
	/run/media/bill/Midas/Investments/TD Canada Trust/TD_statement_visa raw.txt
visa - monthly statements only, the dowloaded info does NOT include pending!?!?
	
don't bother - not enough actions : 
	/run/media/bill/Midas/Investments/TD Canada Trust/221101 TD savings 08Aug2022-02Nov2022.txt
	/run/media/bill/Midas/Investments/TD Canada Trust/221101 TD loc 08Aug2022-02Nov2022.txt
.
HSBC statements update - month-by-month! (arrrggghhh!?!?)
	/run/media/bill/Midas/Investments/HSBC/221101 HSBC chequing <given date>.pdf
	/run/media/bill/Midas/Investments/HSBC/221101 HSBC masterCd <given date>.pdf


02Nov2022 HSBC Aqib - download staterments in csv format?


.
ConnectFirst updates





+--+
Step 2 - process with "$d_Qndfs"'bank statements reformat.ndf' 





+--+
Step 3 - copy/paste from kwrite to sheets



#24************************24


#24************************24
# Setup, ToDos,   


#08********08
#] ??Mar2023 


#08********08
#] ??Mar2023 


#08********08
#] ??Mar2023 


#08********08
#] 02Mar2023 Conn1 statement download conversion, 'bank statements reformat.ndf' not available 
'Howell_extract_codes_script.xba' macros not installed yet after changing Suse -> LMDE
>> sometime in the distant future...

setup manthNum range : 
MMM	num
Jan	1
Feb	2
Mar	3
Apr	4
May	5
Jun	6
Jul	7
Aug	8
Sep	9
Oct	10
Nov	11
Dec	12

Create 4 new columns after 'Balance' : 
Year				MonthMMM			Month#		Day				Dater
=MID($B2,9,4)	=MID($B2,1,3)	see below	=MID($B2,5,2)	=DATE(I2,K2,L2)

I couldn't get simple date(year, minth, day) function to work, so : 
Month# =IF(G2="Jan", 1, IF(G2="Feb", 2, IF(G2="Mar", 3, IF(G2="Apr", 4, IF(G2="May", 5, IF(G2="Jun", 6, IF(G2="Jul", 7, IF(G2="Aug", 8, IF(G2="Sep", 9, IF(G2="Oct", 10, IF(G2="Nov", 11, IF(G2="Dec", 12,0))))))))))))

insert two columns after Description column, 
old [Date, Balance] cols (strings) : 
	search `$ replace null
	search `, replace null
in new cols: =NUMBERVALUE(G2,".")	=NUMBERVALUE(H2,".")

copy-paste to "$d_Midas"'Investments/Conn1/0_Conn1 cheq.ods'  


#08********08
#] 27Jul2022 ???



#08********08
#] 26Sepl2022 update SB_translate_cheq

ary_itm_cut_subL  '8/19/2022'  `/  
>> OK 

I revamped SB_translate_cheq, oops : 
?.. Sb_date := sb_translate_date Sb_date
-->[nextv] 
?no_value - ?no_value ?no_value ?no_value - ?no_value

ary_itm_find_idxL  is no longer working - will have to get back to test arrays.ndf optrs

+-----+
27Jul2022 continued...
see 'arrays.ndf', ary_itm_cut_subL :
ary_chk_itm_apply_optrPhr  '8/19/2022'  `/  "ary_itm_cut_subL  

SB_translate_cheq

# EACH str_removeExtra_SpcTab  'bige elephant   '  '   small    potatoes'  



+-----+
olde code

SB_translate_cheq :
# quack  :=  link 'April 20, 2021'  chr_tab  'Miscellaneous Payment' 
# dater  tranType   :=  ary_itm_cut_subL  quack  chr_tab  
# day  month  year  :=  ary_itm_cut_subL  dater  `  
# str_splitWith_subStr  quack  (link chr_tab  chr_tab)  




# enddoc