pls do in excel office.

Further Details Transaction Ledger Categories Ledger simple example of reconciliatio Payroll start with a simple reporting period of t month Assignment 1: Setting up the GENERAL LEDGER for a Business The General Ledger consists of Transactions and Categories General Ledger is a collection of SUB LEDGERS What are Transactions They are Recordings of MONEY IN and MONEY, Reconciled to CATAGORIES of Business Expenses, within a TIME FRAME Create a business Create some Category Specifics Date of Transaction INCOME Expenses Balance Balance start/ end of reporting period June 1, 2020 $19,435.32 25 Main Street June 15, 2020 $200.00 Grass Mowing Vehicle Repair Truck 4: oil change June 17, 2021 560.00 Flower Planting 45 Ryan Street June 19, 2021 $340,00 Equipment Purchase Buy a new lawn mower June 22, 2021 $945.45 summary 5540.00 $1.00.45 $465.45 you should arrange your ENTRIES so that the total of the expenses MINUS the total of your INCOME is the same the difference between start of month and end of month money Balance start/end of reporting period June 1, 2020 $22,345.00-$2,909.68 A transaction is a recording in the General Ledger of: MONEY IN or MONEY OUT tied to a DATE of occurrence: transaction date and it is coded in the system to a Business INCOME or EXPENSE CATEGORY. (IN LARGE CORPORATE ENVIRONMENTS, YOU HEAR THE TERMS: REVENUE CENTERS AND COST CENTERS: OFTEN EXPRESSED AS CODE NUMBERS If you become a professional accountant, you will spend most of your time at work coming up with cost centres and revenue centres and assigning costs and income to those categories. DUE Date: Follow the instructions in your Section's Google Classroom Page How to start: Download the Excel Starter file. 1. Create your Transactions 2. Create your Reconcilation BUSINESS Note: This a Revision B of Assignment 1 Instructions: The revised instructions are: We are adding a requirement to providing REPORTING OP YOUR TRANSACTIONS BY CATEGORY The business world is run on record keeping systems. Bookkeeping which is the topic or studying here is one example. Other examples include file keeping and organizing systems. Libraries organize books according to the Dewey decimal system which is a way of categorizing books by a variety of standard topics. As we have already figured out that one of our major goals here in accounting land is to produce reports for senior management. Another purpose for accounting is to create an organizational memory so we can refer in the future back to what happened in the past. In all these cases are data would be pretty useless if we could not easily organize it if we had a transaction ledger with thousands of transactions, but they were messed up and not organize that would be useless. Badly organized information is the same as no information So in revision of assignment one you will be updating last week's work and you will be layering in some designators and classifiers for your transactions which you can then output reports using these designators and classifiers. In business accounting and file keeping systems these designators and classifiers are often referred to as categories. For example it is common to file physical pieces of paper and a filing system using the same designator on your file as you used in your general ledger. Some of you may work in offices in an administrative role and will be your job to maintain filing systems like this. So now you know how they work! The Learning Outcomes for Assignment as the connect to your Course Dutline To practice recording business transactions in a General Ledger that you will make for some real or imagined business that you are organizing the General Ledger around. In future assignments, we will keep building up on this. The core concept we need to learn about in this course is the concept of a TRANSACTION: A transaction is a recording in the General Ledger of: MONEY IN OF MONEY OUT tied to a DATE of occurrence: transaction date and it is coded in the system to a Business INCOME or EXPENSE CATEGORY (IN LARGE CORPORATE ENVIRONMENTS, YOU HEAR THE TERMS: REVENUE CENTERS AND COST CENTERS: OFTEN EXPRESSED AS CODE NUMBERS Further Details Transaction Ledger Categories Ledger simple example of reconciliatio Payroll start with a simple reporting period of t month Assignment 1: Setting up the GENERAL LEDGER for a Business The General Ledger consists of Transactions and Categories General Ledger is a collection of SUB LEDGERS What are Transactions They are Recordings of MONEY IN and MONEY, Reconciled to CATAGORIES of Business Expenses, within a TIME FRAME Create a business Create some Category Specifics Date of Transaction INCOME Expenses Balance Balance start/ end of reporting period June 1, 2020 $19,435.32 25 Main Street June 15, 2020 $200.00 Grass Mowing Vehicle Repair Truck 4: oil change June 17, 2021 560.00 Flower Planting 45 Ryan Street June 19, 2021 $340,00 Equipment Purchase Buy a new lawn mower June 22, 2021 $945.45 summary 5540.00 $1.00.45 $465.45 you should arrange your ENTRIES so that the total of the expenses MINUS the total of your INCOME is the same the difference between start of month and end of month money Balance start/end of reporting period June 1, 2020 $22,345.00-$2,909.68 A transaction is a recording in the General Ledger of: MONEY IN or MONEY OUT tied to a DATE of occurrence: transaction date and it is coded in the system to a Business INCOME or EXPENSE CATEGORY. (IN LARGE CORPORATE ENVIRONMENTS, YOU HEAR THE TERMS: REVENUE CENTERS AND COST CENTERS: OFTEN EXPRESSED AS CODE NUMBERS If you become a professional accountant, you will spend most of your time at work coming up with cost centres and revenue centres and assigning costs and income to those categories. DUE Date: Follow the instructions in your Section's Google Classroom Page How to start: Download the Excel Starter file. 1. Create your Transactions 2. Create your Reconcilation BUSINESS Note: This a Revision B of Assignment 1 Instructions: The revised instructions are: We are adding a requirement to providing REPORTING OP YOUR TRANSACTIONS BY CATEGORY The business world is run on record keeping systems. Bookkeeping which is the topic or studying here is one example. Other examples include file keeping and organizing systems. Libraries organize books according to the Dewey decimal system which is a way of categorizing books by a variety of standard topics. As we have already figured out that one of our major goals here in accounting land is to produce reports for senior management. Another purpose for accounting is to create an organizational memory so we can refer in the future back to what happened in the past. In all these cases are data would be pretty useless if we could not easily organize it if we had a transaction ledger with thousands of transactions, but they were messed up and not organize that would be useless. Badly organized information is the same as no information So in revision of assignment one you will be updating last week's work and you will be layering in some designators and classifiers for your transactions which you can then output reports using these designators and classifiers. In business accounting and file keeping systems these designators and classifiers are often referred to as categories. For example it is common to file physical pieces of paper and a filing system using the same designator on your file as you used in your general ledger. Some of you may work in offices in an administrative role and will be your job to maintain filing systems like this. So now you know how they work! The Learning Outcomes for Assignment as the connect to your Course Dutline To practice recording business transactions in a General Ledger that you will make for some real or imagined business that you are organizing the General Ledger around. In future assignments, we will keep building up on this. The core concept we need to learn about in this course is the concept of a TRANSACTION: A transaction is a recording in the General Ledger of: MONEY IN OF MONEY OUT tied to a DATE of occurrence: transaction date and it is coded in the system to a Business INCOME or EXPENSE CATEGORY (IN LARGE CORPORATE ENVIRONMENTS, YOU HEAR THE TERMS: REVENUE CENTERS AND COST CENTERS: OFTEN EXPRESSED AS CODE NUMBERS