Instructions

For Automated Accounting

The program is designed for beginning accounting students. It features a general ledger for a merchandising business. The accounts used are typical of most businesses and include assets, liabilities , equity accounts, revenue and expenses. All account ending balances appear on the trial balance. The program then sorts out ones that belong on either the income statement, stockholders' equity statement or the balance sheet. When all numbers are entered, press the Post All Accounts button to see the results. Each report shows the name of the account and the amount. Totals are also included that show total debits and credits on the trial balance, total revenue and expenses and net income as well as total assets, liabilities and stockholders equity.
Exercise to use with the program

Entering company name and date

  1. Click in the box for company name and type in the name of your company.
  2. Click in the calendar icon in the date box. Chrome and Firefox have a date picker.
  3. The current date comes up.
  4. Click on it to select that date.
  5. If you want another date, scroll through the months and then select the day.
  6. You can also just click on the month, day and year and enter the date you want to appear on the statements.

Entering beginning balances

  1. Initially all balances are set to zero.
  2. Just click in the beginning balance box for each account.
  3. Backspace once to erase the 0.
  4. Then enter your beginning balance
  5. If you wish, you may leave the zero in front of the number you enter.
  6. Enter all balances
  7. Make sure that all accounts have a balance. If you erase the zero and do not enter a number you will get a NAN error
  8. NAN stands for not a number.
  9. Just go back to the account that shows the error, enter a zero and click post All Accounts button again

Taking a trial balance

  1. Click on the Post All Accounts button.
  2. Look at the totals of the trial balance. They must be the same number.
  3. If you are out of balance, first find the difference between the numbers.
  4. You might recognize this number as one that was or was not entered.
  5. Divide the difference by 2. This could show if you posted a debit for a credit or visa versa.
  6. Or find the difference and divide that number by 9.
  7. If the answer comes out as a whole number, you probably transposed a number. Check for this.
  8. After correcting the number or numbers, Click the Post All Accounts button again. Check for balance.
  9. If you see NAN for one of your balances, It means that you did not enter a number for that account. Just enter a zero to clear the error and click Post All Accounts button.

Income statement, Stockholders' Equity statement and Balance Sheet

  1. Directly below the trial balance is the income statement
  2. The revenue accounts and sales returns accounts appear first. They are totaled
  3. You need to adjust the Merchandise Inventory account. Debit the account the amount of the ending inventory.
  4. The beginning inventory appears on the trial balance and income statement.
  5. The ending inventory also appears on the income statement and balance sheet.
  6. Cost of goods sold is calculated. Gross profit is also calculated.
  7. The expenses are listed and totaled.
  8. The net income or net loss is then calculated and displayed.
  9. The stockholders' statement appears below the income statement.
  10. It shows the original capital or common stock balance, beginning retained earnings, net income, ending balance and then the total of liabilities and stockholders' Equity
  11. The balance sheet is next. It shows assets, liabilities and stockholders equity.

How to print reports

  1. Click the print this page button.
  2. A print preview is displayed.
  3. Select the pages you want to print.
  4. Click Print.

Closing the books

  1. At the end of each month, you must close the books.
  2. First look at the net income and write it down.
  3. Next we will close the revenue accounts.
  4. Revenue accounts have credit balances, therefore we will debit them.
  5. Click in the debit posting field and debit the account the same amount as the balance in the account.
  6. Sales returns has a debit balance. Credit it the amount of its balance.
  7. Next, we need to close all the expense accounts.
  8. Expense account have debit balance, therefore we will credit them using their ending balance.
  9. If there is a net income, credit the Retained Earnings account the amount of net income.
  10. If there is a net loss, debit the Retained Earnings account the amount of the loss.
  11. Click Post to All Accounts button.
  12. When we click the Post All Accounts button, all revenue and expense accounts will have a zero balance.
  13. Check to see that in the trial balance and income statement that all revenue and expense accounts have no balances.
  14. Print the trial balance out. This is called a post-closing trial balance.

Next month's books

  1. Take your post-closing trial balance or your ending balance sheet, the ones you printed out after closing the books.
  2. This trial balance will be your source document. You can also use your ending balance sheet.
  3. It only has balances for asset, liability and stockholders' equity accounts.
  4. These numbers will be your beginning balances for the new month.
  5. Set up these begining balances.
  6. Click the Post All Accounts button.
  7. Check to see that you are in balance.
  8. Correct if needed.
  9. Enter transactons for the new month.

To Customize Accounts

  1. A standard chart of accounts was chosen that covers most accounts.
  2. There are couple of special accounts based on the type of business: Dry Cleaning Expense and Alterations Expense.
  3. To change the names of these, you need to see the source code for the project.
  4. Chrome, Firefox and Edge allow you to see and capture the code on the clipboard.
  5. Right click on any area that is blank and view the source.
  6. Drag the entire application and then put it on the clipboard using CTRL+C.
  7. Open Notepad++, start a new file and the paste the contents of the clipboard using CTRL+V
  8. Save the application using an HTML extension.
  9. You look through the code and find the lines of code and retype them with the account you want or you can use search and Replace function in Notepad++
  10. For example, suppose that you wanted to change the name of the Other Assets account name to Tuxedos.
  11. The lines that would need to be changed are 1761, 864, 1274, 1959. Substitute asset name for Other Assets.
  12. To use the search replace method, click on Search, Find, Replace, key in the words you want to find and replace, then click Replace All, Close the box.
  13. Alterations Expense can be found on lines 1148, 1321, 1855, 1971
  14. Delivery Expense can be found on lines 1242, 1352, 1188, 1989.