Question

In: Accounting

How do I create a double ledger accounting system, with a chart of accounts, calculate my...

How do I create a double ledger accounting system, with a chart of accounts, calculate my fixed and variable costs to ultimately verify estimated profits for an estimated job quote?

Solutions

Expert Solution

You can create a Double ledger accounting system either by using a specific accounting software or you can create excel system on your self.

Excel system is the most cost effcetive incase of any budget constraints. Also it is convinient for small businesses or individual. However it lacks control and getting historic data shall be difficult until unless you maintain the system in such a way as to get the whole historic data.

You may Prepare a Balance Sheet, Capital And Profit and Loss Account whereby you can give double entry impact in each ledger. You can assign a chart of accounts i.e. general Ledger No. to each account you want to maintain and while passing the entry in a separate sheet, you just need to assign the specific GL no. to it.

Regarding the Fixed and variable costs to verify profits for estimated job quote

You shall have to maintain a separate column to maintain if the cost is Fixed or variable and also assign such cost to each job to identify the fixed and variable cost

You can do this by creating separate excel or a specific Sotware like SAP, Oracle Tally etc shall help


Related Solutions

Create General Ledger entries based on the information given. Chart of accounts: 1001 Cash 1006 Accounts...
Create General Ledger entries based on the information given. Chart of accounts: 1001 Cash 1006 Accounts Receivable 1019 Merchandise Inventory 1124 Office supplies 1125 Store supplies 1128 Prepaid insurance 1163 Office equipment 1164 Accumulated Depreciation - Office equipment 1165 Store equipment 1166 Accumulated Depreciation - Store equipment 2001 Accounts payable 3001 Skip Slider, Capital 3002 Skip Slider, Withdrawals 4013 Sales 4014 Sales discounts 4015 Sales returns and allowances 5002 Cost of goods sold 6012 Depreciation expense - Office equipment 6013...
A chart of accounts for a business: Select one: a. lists the accounts in the ledger....
A chart of accounts for a business: Select one: a. lists the accounts in the ledger. b. shows the balance of each account in the general ledger. c. is a graph. d. indicates the amount of profit or loss for the period.
Define in own words CHAPTER 5 – Accounting Systems Accounting system Accounts payable subsidiary ledger Accounts...
Define in own words CHAPTER 5 – Accounting Systems Accounting system Accounts payable subsidiary ledger Accounts receivable subsidiary ledger Cash payments journal Cash receipts journal Controlling account e-Commerce General journal General ledger Internal controls Invoice Purchases journal Revenue journal Special journals Subsidiary ledger
The accounts used by Crystal Clear Cleaning are provided in the Chart of Accounts (click on “Chart of Accounts” to view). The accounts have already been opened in the General Ledger (click on “General Ledger” to view).
12/02/2017 Purchased 475 units of inventory for $2,850 on account from Sparkle, Co. on terms, 3/10, n/20. 12/05/2017 Purchased 600 units of inventory from Borax on account with terms 2/10, n/30. The total invoice was for $4,500, which included a $150 freight charge. 12/07/2017 Returned 75 units of inventory to Sparkle from the December 2 purchase. 12/09/2017 Paid Borax. 12/11/2017 Sold 285 units of goods to Happy Maids for $3,990 on account with terms 3/10, n/30. 12/12/2017 Paid Sparkle. 12/15/2017...
Complete accounting cycle Instructions Chart of Accounts Labels and Amount Descriptions Work Sheet Journal Ledger Unadjusted...
Complete accounting cycle Instructions Chart of Accounts Labels and Amount Descriptions Work Sheet Journal Ledger Unadjusted Trial Balance Adjusted Trial Balance Income Statement Statement of Stockholders’ Equity Balance Sheet Post-closing Trial Balance X Instructions For the past several years, Steffy Lopez has operated a part-time consulting business from his home. As of July 1, 20Y2, Steffy decided to move to rented quarters and to operate the business, which was to be known as Diamond Consulting, on a full-time basis. Diamond...
How Do I Calculate Accounts Receivable Turnover Ratio? Give An Example.
How Do I Calculate Accounts Receivable Turnover Ratio? Give An Example.
What are general accepted accounting principles? How is the double entry system used? What do debit...
What are general accepted accounting principles? How is the double entry system used? What do debit and credit mean? What is a bond and how do investors decide how much to pay for a bond? What are the four basic financial statements and what is the purpose of each?
Review the chart of accounts in Ch 2. In Excel, create a four column chart of...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following: List at least 16 accounts. At least 6 account titles should...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following: List at least 16 accounts. At least 6 account titles should...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following: List at least 16 accounts. At least 6 account titles should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT