tag:blogger.com,1999:blog-80369247175939017942026-10-21T07:54:43.120+08:00I show you how to use Microsoft Excel as complete Accounting system.Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.comBlogger202125tag:blogger.com,1999:blog-8036924717593901794.post-24788639178989706402026-10-21T07:33:40.157+08:002026-10-21T07:54:43.120+08:00

34. This System And Its Suitability Suitability Of This System In reviewing the suitability of this system, here are the factors to consider: Size Of Business This file is suitable for small and medium-sized businesses. As long as the number of rows to be used does not exceed 65,536 in a year, you can use it. The type of industry is also not important - it can be used for in a trading

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-86238321775290102082026-10-20T07:25:24.427+08:002026-10-20T07:48:49.194+08:00

33. Book-Keeping Primer A Beginner's Guide On Book-Keeping What Is Book-keeping? Book-keeping is a way to record financial transactions of a business entity and to determine particularly its profits, assets, capital, and liabilities at particular intervals. The first record is to record the capital introduced to start the business. The capital usually is in the form of assets (cash,

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-74420830191941775372026-10-19T07:12:21.821+08:002026-10-19T07:44:39.482+08:00

32. AdvanceFilter Primer A Beginner's Guide On AdvanceFilter We use the AdvanceFilter function when we want to filter our data in the data area (database) based on more than one column title. If we want to filter our data in the data area (database) based on one column title only, we use AutoFilter. We can access the AdvanceFilter function by clicking on the menu Data/Filter/AdvanceFilter.

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-61537879617298839112026-10-18T06:54:58.761+08:002026-10-18T07:12:48.593+08:00

Creating A PivotTable Based On An Existing report When we create a PivotTable based on data in a data area, usually we will not use (drag) all the buttons (which represent the column titles of the data area) into the PivotTable layout. However, the remaining buttons are effectively available in the PivotTable we created, though hidden. So, we can use the same PivotTable report to build a new

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-24884614315055952082026-10-18T06:49:12.140+08:002026-10-18T07:17:53.193+08:00

Building Another Report Based On Same Data Area If you want to create another report, you may get this dialog: Microsoft Excel Your new report will use less memory if you base it on your existing report [Book2]Sheet2!PivotTable3, which was created from the same source data. Do you want your new report to be based on the same data as your existing report? If you click Yes, you will save

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-44144014978823481782026-10-18T06:43:21.350+08:002026-10-18T06:46:46.714+08:00

Editing Your PivotTable Report You can format the report and the content of the report in the normal way you use formatting in Excel. For instance, you can format numbers, font etc. You can also change or edit the content (numbers and words) in the report the normal way we do in Excel. The report does not contain any formulas. You can delete the sheet and the Report to save disk space, if

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-20137756382647975652026-10-17T16:59:49.049+08:002026-10-17T18:02:18.998+08:00

Below is a sample result and its explanation: A     B C D E F G 2 3 MTH 4 ITEM SOLD  Data         1 2 3 4 Grand Total 5 Model A    Sum of QTY 249,048 203,897 282,726 49,324 784,995 6    Sum of RM CREDIT (1,323,990) (1,099,449) (1,521,920) (260,878) (4,206,237) 7 Model B    Sum of

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-48060021864373721552026-10-17T08:03:55.989+08:002026-10-17T08:26:47.888+08:00

8. The top portion (above the grey line) contains simple instructions only. On the right side are buttons representing titles in the title row of your data area. You can drag any one button at a time to either the PAGE, COLUMN, ROW or DATA box on the left and release it there. If you drag and release the button in the PAGE box, each unique title item available in the data area will appear as

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-38015126911093427452026-10-16T07:12:33.034+08:002026-10-17T08:03:16.392+08:00

Generating PivotTable Report PivotTable is used to summarize data in the data area. It can find totals (values or quantities) of a unique item in the data area and combinations of more than one unique item in the data area. 284 NOTE You can construct a data area with following details: If you want to try the following steps, make sure you have a data area ready. Fill adjacent cells in a

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-12721377051985356262026-10-15T07:38:44.486+08:002026-10-15T08:01:51.865+08:00

31. PivotTable Operation Primer A Beginner's Guide On PivotTable Operations The PivotTable function is accessible from the menu Data/PivotTable and PivotChart report. This function can be used to generate summaries of our database. Valid Data Areas Before we are able to use it, we must have a proper data area (or database area). A data area is a rectangular area of rows and columns. The

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-34586080634255785032026-07-25T18:12:12.702+08:002026-07-25T18:12:12.703+08:00

This blog is not completed yet

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-90939694302772834692026-07-24T15:20:00.000+08:002026-08-09T16:10:53.617+08:00

BOOK-KEEPING WITH MICROSOFT EXCEL You can use Microsoft Excel for all your book-keeping tasks, from recording raw data to preparation of Trial Balance, Balance Sheet, Profit & Loss statement, and other reports. This book shows you how. ISMAIL HASHIM

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-83427189138492005102024-08-30T19:00:00.000+08:002026-08-15T12:36:07.555+08:00

Excel 95, 97, 2000, XP Microsoft Excel has long been used to help in book-keeping tasks. Many businesses rely on Excel to manage their book-keeping chores. There are many different ways to implement it. This book shows one way, may be a better way. In this book, formulas are used to automate updating of Trial Balance, Balance Sheet, Profit & Loss and other reports. Only a few formulas

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-68636410187378324902024-07-30T14:50:00.000+08:002026-07-31T10:54:24.780+08:00

Introduction Here I show how to use Microsoft Excel as a complete book-keeping accounting tool. Useful for freelancers, book-keeping service provider, small businesses, students and for those who want to work from home. VBA is NOT used at all.  Developing A Book-Keeping System With Microsoft Excel Microsoft Excel has long been used to help in book-keeping and accounting tasks. Many

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0Taman Sri Muda, Shah Alam, Selangor, Malaysia3.0279061 101.533330699999963.0158871 101.52058619999997 3.0399251 101.54607519999996tag:blogger.com,1999:blog-8036924717593901794.post-34576653495269522242024-07-25T11:00:00.000+08:002026-08-15T12:38:21.605+08:00

Some Book-Keeping Functions That Can Be Done Using Microsoft Excel Here are some of the book-keeping functions that can be performed using Microsoft Excel, and that will be shown in this book: To record raw data. To automate updating of the Trial Balance statement. To automate updating of the Balance Sheet statement. To automate updating of the Profit & Loss statement. To generate and update

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-31039712677861116652024-07-20T08:40:00.000+08:002026-07-30T08:42:01.859+08:00

REQUIREMENTS What are required to successfully implement book-keeping with Microsoft Excel ? 1. Initially, an empty Microsoft Excel file (Excel 95, 97, 2000, XP). 2. A basic book-keeping knowledge (particularly understand the concept of Debit and Credit). 3. A basic knowledge and hands-on experience in Microsoft Excel.

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-49975088819429266102011-07-29T12:15:00.000+08:002026-07-29T19:50:24.546+08:00

Reasons : From staff view : If allowed and wish, he can bring home the work and finish at home, so the next day, there would be more time for him to do other works. From Head of Dept view : He can ask for a copy of the file and look for it at home. At home, he can jot any query to be presented to his staff in next day. If the file is in cloud, both persons ie staff and Head of Accounting

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-60644231755300058732011-07-28T19:50:00.000+08:002026-07-29T19:53:18.960+08:00

TABLE OF CONTENT CHAPTER 1 – BOOK-KEEPING FUNCTIONS THAT CAN BE DONE USING EXCEL CHAPTER 2 – REQUIREMENTS FOR IMPLEMENTATION OF BOOK-KEEPING WITH EXCEL BUILDING THE STRUCTURE CHAPTER 3 – STEP 1 – CREATE A FOLDER (DIRECTORY) CHAPTER 4 – STEP 2 – CREATE AND SET A FILE (WORKBOOK) CHAPTER 5 – STEP 3 – SET THE WORKSHEETS IN THE FILE CHAPTER 6 – STEP 4 – SET THE STRUCTURE IN THE SHEET ‘DATA’

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-56481994561773818852011-07-28T16:05:00.000+08:002026-07-31T16:06:10.429+08:00

Here are the steps to develop a book-keeping system with Microsoft Excel. Step 1- Create A Folder (Directory) You should be familiar with the Windows computer operating system and know how to create a folder in a disk. Now, create a new folder in an easy-to-access path, such as in the root directory of disk C, not in a sub-folder. Give it an easy-to-remember name, say: AccountsXL. So, the

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-52020218896346268682011-07-28T16:00:00.000+08:002026-07-31T16:08:48.545+08:00

Step 2 - Create And Set A File (Workbook) After you create a folder, open Microsoft Excel (95, 97, 2000 or XP). Then, create a new blank Microsoft Excel file (menu File/New). In Excel, a file is called a workbook. Save the file into the AccountsXL folder (or some other folder of your choice). Give the file this (suggested) name: 0000 Book-Keeping Sample.xls. You can use some other name if you

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-33129130079322554872011-06-29T23:40:00.000+08:002026-08-04T10:38:36.138+08:00

- Open a new workbook (This will automatically create a blank workbook). - Save the new workbook. In the process of saving a new workbook, you will be asked to give a name for the workbook. Give the new workbook a suitable name that reflect what data it will contain. For example, if the name is "AccJan2012.xls" it will contain accounting data for January 2012. Other than name, you also be

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-50518583802891253512011-06-28T22:00:00.000+08:002026-08-03T18:43:53.672+08:00

Where to enter data 1. Use a dedicated sheet. 2. Name the sheet appropriately. In this book, its name is "Data". This name is used in formulas in this book. Sample structure ABCDEFGHIJ 1SRCDATEMTHSRC. NO.2ND SRC. NO.Note 1Note 2Note 3Note 4Note 5 2 3 4 5 6 7 8 9Subtotal 10Checking 11Cut-off Date(date) 12LastRowDATA(formula) KLMNO 1ACCOUNTSAmountsCum. AmountsCheck AccountsBank Recon. 2(formula)

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0Taman Sri Muda, Shah Alam, Selangor, Malaysia3.0279061 101.533330699999963.0158871 101.52058619999997 3.0399251 101.54607519999996tag:blogger.com,1999:blog-8036924717593901794.post-78550125319089288892011-06-28T18:30:00.000+08:002026-08-03T18:42:06.693+08:00

Explanation for the sample structure 1. Cells in row 1 from A1 to N1 are to contain headings. 2. Column O serves as the right-side border. Colour its cells as visual indicator. 3. Rows for transaction data starts at row 2. 4. Let the range A2:N7 as the initial Data Area. The Data Area is dynamic as it will expand or contract as we add more row/s or delete row/si. 5. Make the row immediately below

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-79181458761287085132011-06-28T17:30:00.000+08:002026-08-04T18:34:39.506+08:00

Row 1 In cell Al, type: TOTAL/SUBTOTAL This is to indicate that some of the other cells in row 1 are used to accommodate formulas which calculate totals/subtotals. In cell H1, write this formula: SUBTOTAL (9, INDIRECT("H5: H30000")) This formula calculates the total of amounts in cells in column H (from row 5 to row 30,000). (We will see later that cells H5 to H30000 will contain

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0tag:blogger.com,1999:blog-8036924717593901794.post-41747392380984283312011-06-28T17:00:00.000+08:002026-08-20T15:16:16.540+08:00

Later on, when you add more data into rows below it, just copy the formula down. NOTE We set the name CutoffDate to refer to a cut-off date by using the menu Insert/Name/Define. When we click this menu, the Define Name dialog box shown below will appear. In the box below the label Names in workbook, write the name Cutoff Date. In the box below the label Refers to, write the date it refers to.

Mael Hashimhttp://www.blogger.com/profile/12112000937690547018noreply@blogger.com0