The structure for raw data in "Transactions" sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	ACT	SRC DOC	SRC DOC NO.	DATE OF SRC DOC	MTH	NOTE	OTHER REF	FC	EXCH RATE	COMPUTED	ACCOUNTS	RM	CUM RM	CHECK ACC	BANK RECON	HOLD	SALES INV STATUS	DEBT AGE	DEBT AGE GROUP	SALES TERM	SALES DUE DATE	ITEM SOLD	QTY SOLD	UNIT OF SALE	SELLING PRICE	PUR INV STATUS	CREDIT AGE	CREDIT AGE GROUP	PUR TERM	PUR DUE DATE	ITEM PUR	QTY PUR	UNIT OF PUR	PUR PRICE	ORI ORDER
2	OB
3	Sales
4	Purchases
5	Cash In
6	Cash Out
7	Bank in
8	Bank out
9	Accruing
10	Provisioning
11	Journal adj
12	Audit Adj

Notes :
- One sheet for 1 year of financial transactions data.
- In this book, the sheet that contain the transactions data is named Transactions.
- The name Transactions used throughout this book refers to the transactions data.
- The name Transactions used in any functions parameters refers to the transaction data.
- The structure in the sheet Transactions is as above.
- About the structure and how to fill the structure :
- Row 1 contains the data titles.
- Data must start from row 2.
- No blank cell between the titles in row 1.
- No blank cell between the row in column A.
- The data area of the transactions begin from row 1 to any filled row.
- A blank row below the data area will be treated as the bottom border of the data area.
- The right border of the data area is column AJ.
- Fill cells in data area with transactions data.
- The spelling of an Accounts name in column ACCOUNTS must be the same with the spelling of the Accounts name available in column ACCOUNTS in sheet "TB".
- Total RM in column RM is exported to column RM in sheet "TB" using function SUMIF.
- There are many functions being used in the structure.
- Example of functions are : .....
- A change in content of a cell in column RM in Transaction sheet automatically update relevant cell in sheet TB.
- To go to the most bottom row of the data area ....
- To check that the Transactions is balance ...
- To remove the unuse column (to conserve memory) is ...