{"id":31650,"date":"2017-05-10T14:33:10","date_gmt":"2017-05-10T06:33:10","guid":{"rendered":"https:\/\/zahiraccounting.com\/en-my\/?p=31650"},"modified":"2017-05-10T14:33:10","modified_gmt":"2017-05-10T06:33:10","slug":"using-excel-for-bookkeeping","status":"publish","type":"post","link":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html","title":{"rendered":"Using Excel For Bookkeeping"},"content":{"rendered":"

\"Using<\/a><\/p>\n

Managing the business financial records needs big responsibility. Keeping the accurate records to create a financial statement, such as balance sheet, income statements, expense reports, and others are necessary to support the owner in making business decision. How about if we manage the business financial using excel for bookkeeping ?<\/p>\n

One of the simple tools to create financial statement is using Excel. Microsoft Excel is a program which allows the users to make a custom spreadsheet as needed. \u00a0For instance, users can record cash receipt in one sheet, cash disbursement in another, and summary in the third sheet. By using excel for bookkeeping , the financial and statistical functions possibly presented in various charts.<\/p>\n

Spreadsheets allow the users to format numbers for currency or dates, perform addition, subtraction, multiplication, and division. When you already have the data, you can entry your data records and will be calculated automatically. In general, creating financial reports using Excel for bookkeeping are :<\/p>\n

    \n
  1. Open Microsoft Excel and start a new workbook by selecting \u201cFile\u201d and \u201cNew\u201d.<\/li>\n
  2. Set how many worksheets you want to make for your accounts, such as for expenses, income, or tax.<\/li>\n
  3. Put headings for each data item to be recorded. For instance, for income, you can put the date, product, service, or customer name as the heading.<\/li>\n
  4. Enter income and expenses data. You can edit the columns to ensure you can accommodate your data. Format your worksheet by selecting each column in turn. When formatting is applied, the data in the column will be automatically formatted.<\/li>\n
  5. You can calculate your income and expenses in your worksheet. A calculation is performed by clicking and dragging to select the cell contains the number to be added (a) and an empty cell below (b). Click the AutoSum button or enter the sum formula \u201c=SUM\u201d followed by the cells to be added, e.g. =SUM(A1:A5), means to sum all the values in cell A1 and A5.<\/li>\n
  6. Calculate your balance in your balance sheet based on the data in your income and expenses tables. For instance, to select a cell in the balance sheet and enter \u201c=\u201d, select income sheet and click total income, enter \u201c-\u201d then select expenses sheet, click the total expenses, press Enter, then the total balance is displaying in the new sheet.<\/li>\n
  7. To display various charts, simply click the Insert tab\u2019s charts buttons to create bookkeeping data into pie charts, bar graphs or others.<\/li>\n<\/ol>\n

    Microsoft Excel allows users to share bookkeeping with your staff. You can send the file and ask your staff to give comment using commenting features. This is necessary to prevent error or monitor the record accuracy. Another benefit of using Excel is, its information can be imported to Word Document.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Managing the business financial records needs big responsibility. Keeping the accurate records to create a financial statement, such as balance […]<\/p>\n","protected":false},"author":11,"featured_media":31668,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[39,38,37],"yoast_head":"\nUsing Excel For Bookkeeping | Zahir Malaysia Blog<\/title>\n<meta name=\"description\" content=\"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Excel For Bookkeeping | Zahir Malaysia Blog\" \/>\n<meta property=\"og:description\" content=\"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html\" \/>\n<meta property=\"og:site_name\" content=\"Best Accounting Software in Malaysia | Zahir\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-10T06:33:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sri Warni\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/#website\",\"url\":\"https:\/\/zahiraccounting.com\/en-my\/\",\"name\":\"Best Accounting Software in Malaysia | Zahir\",\"description\":\"The Best Accounting Software\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zahiraccounting.com\/en-my\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png\",\"contentUrl\":\"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png\",\"width\":1080,\"height\":1080,\"caption\":\"Using Excel for bookkepping\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#webpage\",\"url\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html\",\"name\":\"Using Excel For Bookkeeping | Zahir Malaysia Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#primaryimage\"},\"datePublished\":\"2017-05-10T06:33:10+00:00\",\"dateModified\":\"2017-05-10T06:33:10+00:00\",\"author\":{\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/#\/schema\/person\/8e37c545fd63450fd5a39dd664cf2dd7\"},\"description\":\"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?\",\"breadcrumb\":{\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zahiraccounting.com\/en-my\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Excel For Bookkeeping\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/#\/schema\/person\/8e37c545fd63450fd5a39dd664cf2dd7\",\"name\":\"Sri Warni\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/zahiraccounting.com\/en-my\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9e3578c46b00cdae62128ee312ec7c5c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9e3578c46b00cdae62128ee312ec7c5c?s=96&d=mm&r=g\",\"caption\":\"Sri Warni\"},\"url\":\"https:\/\/zahiraccounting.com\/en-my\/author\/iien\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Excel For Bookkeeping | Zahir Malaysia Blog","description":"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html","og_locale":"en_US","og_type":"article","og_title":"Using Excel For Bookkeeping | Zahir Malaysia Blog","og_description":"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?","og_url":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html","og_site_name":"Best Accounting Software in Malaysia | Zahir","article_published_time":"2017-05-10T06:33:10+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png","type":"image\/png"}],"twitter_card":"summary","twitter_misc":{"Written by":"Sri Warni","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/zahiraccounting.com\/en-my\/#website","url":"https:\/\/zahiraccounting.com\/en-my\/","name":"Best Accounting Software in Malaysia | Zahir","description":"The Best Accounting Software","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zahiraccounting.com\/en-my\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#primaryimage","inLanguage":"en-US","url":"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png","contentUrl":"https:\/\/zahiraccounting.com\/en-my\/wp-content\/uploads\/2017\/05\/Using-Excel-for-bookkepping-1080x1080.png","width":1080,"height":1080,"caption":"Using Excel for bookkepping"},{"@type":"WebPage","@id":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#webpage","url":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html","name":"Using Excel For Bookkeeping | Zahir Malaysia Blog","isPartOf":{"@id":"https:\/\/zahiraccounting.com\/en-my\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#primaryimage"},"datePublished":"2017-05-10T06:33:10+00:00","dateModified":"2017-05-10T06:33:10+00:00","author":{"@id":"https:\/\/zahiraccounting.com\/en-my\/#\/schema\/person\/8e37c545fd63450fd5a39dd664cf2dd7"},"description":"Keeping the accurate records to create a financial statement are necessary. How about if we manage the business financial using excel for bookkeeping ?","breadcrumb":{"@id":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/zahiraccounting.com\/en-my\/31650-using-excel-for-bookkeeping.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zahiraccounting.com\/en-my\/"},{"@type":"ListItem","position":2,"name":"Using Excel For Bookkeeping"}]},{"@type":"Person","@id":"https:\/\/zahiraccounting.com\/en-my\/#\/schema\/person\/8e37c545fd63450fd5a39dd664cf2dd7","name":"Sri Warni","image":{"@type":"ImageObject","@id":"https:\/\/zahiraccounting.com\/en-my\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/9e3578c46b00cdae62128ee312ec7c5c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9e3578c46b00cdae62128ee312ec7c5c?s=96&d=mm&r=g","caption":"Sri Warni"},"url":"https:\/\/zahiraccounting.com\/en-my\/author\/iien"}]}},"_links":{"self":[{"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/posts\/31650"}],"collection":[{"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/comments?post=31650"}],"version-history":[{"count":5,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/posts\/31650\/revisions"}],"predecessor-version":[{"id":31673,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/posts\/31650\/revisions\/31673"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/media\/31668"}],"wp:attachment":[{"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/media?parent=31650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/categories?post=31650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zahiraccounting.com\/en-my\/wp-json\/wp\/v2\/tags?post=31650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}