Posts

Showing posts from November, 2024

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...

Trial Balance

A B C 1 ACCOUNTS RM 2 3 4 5 6 7 8 9 10 Notes : - One Trial Balance for 1 year of financial transactions data. - In this book, the sheet that contain the Trial Balance is named TB. - The name TB used throughout this book refers to the Trial Balance. - The name TB used in any functions parameters refers to the Trial Balance. - The structure in the sheet TB is as above. - About the structure and how to fill the structure : - Row 1 contains the data titles. - Data...