1. Export the Journal, Trial Balance, Profit and Loss and Balance Sheet as Excel and Adobe PDFs. The date range is 10/1/20XX to 10/30/20XX.
2. Use these file names:
Exercise 3-2_October Journal
Exercise 3-2_October Trial Balance
Exercise 3-2_October Profit and Loss
Exercise 3-2_October Balance Sheet
Hint: Another way to save Adobe PDF files is to Export to Excel and save the file. Then, on Excel’s file menu, click File > Save as Adobe PDF > Convert to PDF > go to the location to save the PDF file. Steps are included in Appendix A, Troubleshooting.
Troubleshooting:
1) If exporting to Excel is not working, exit Excel and try again. Or¸ sign out and sign back in.
2) If your Journal shows a blank Undeposited Funds entry for the current date with a zero balance, refer to Appendix A, Undeposited Funds. This is a default entry and is okay.
Check Your Figures:
· Account No. 101 Checking, $50,457.56
· Account No. 401 Sales, $6,000.00
· Account No. 601 Advertising, $125.00
· Account No. 605 Dues & Subscriptions, $150.00
· Account No. 619 Meals and Entertainment, $126.40
· Account No. 621 Office Supplies, $226.85
· Account No. 627 Shipping and delivery expense, $47.00
· Net income, $4,457.56
· Total Liabilities and Equity, $69,457.56