Profit Loss Report Spreadsheet

Profit Loss Report Spreadsheet

Organize small organization income and costs. Be prepared for tax season. Don't send your hard-earned money to the tax collector because you don't have an accurate record of the qualified deductions.
Profit Loss Report Spreadsheet is often a basic choice to accounting software package for a tiny home business to organize and track earnings and costs. Designed to save you time and money. And, YES, it may possibly even support minimize Tax Time headaches. Makes it less complicated for you or your tax preparer to fill out Schedule C or other tax types when tax time rolls about.
Combine the energy of a personal computer with all the ease of a calculator. If you have outgrown the receipt shoebox organization technique, but are not rather ready for full-blown accounting application, Profit Loss Report Spreadsheet is for you!

1.   Enter Data.

No complicated setup to customize your report. Be ready in a few minutes.

• Company Name: Name you want to appear on the report.
• Tax Year: Current tax year to show up on the report and monthly expenses pages.
• Contact Person: Name you want to appear as the point of contact for the report.
• Contact E-mail: E-mail address, phone number or any other method to reach the contact person.
• Vendor Names & Income Sources: list of vendors and income sources. Add them to the list one time (at any time), then just select from a list when you enter their expense or income. Add as many rows as you need for your list. Sort names with one click.
• Currency Symbol: Select the symbol you would like displayed. (e.g $ = Dollars, £ = Pounds, € = Euro)
• Customize headings: Change the headings for the entry categories. Includes main and sub-titles.

•2.     Enter Expenses.

Easily organize income and expenses for business management and tax preparation.

• Date: For each month, enter the date of your income or expense.
• Ref #: Enter reference or check number, CASH, CC or other method of payment.
• Vendor Names & Income Sources: Use drop-down list to select the vendor or income source. Add new vendors and sources on the Data tab at any time, so you only have to type their name one time. You even can filter by vendor name with only two clicks to see expenses or income by specific vendor.
• Categories: Include up to six income sources. Expenses and Cost of Goods organized like you need them (U.S. Self-Employment tax form). Change to anything you like from the Data tab.
• Comment: Place to add a comment about 'other' expenses or whatever you like.

•3.     View Report.

Save time and increase accuracy. Totals are calculated automatically for you.

• Report heading: See tax year, company name and contact information in report heading.
• Profit-Loss: Automatically calculates and shows if you have a Profit or Loss for the year. Instantly updates when you add new expenses or monthly income.
• Income: Displays income for the month for up to six income sources. Immediately see your Profit-Loss status, as well as quarterly and yearly totals.
• Expenses: Automatically organized by month, quarter and year. See everything at a glance.
• Cost of Goods: If you sell products, the report will show you what it cost you to acquire the products. You will see purchase, materials, labor, and other organized by month, quarter, and year.
• Pie Charts: Report page displays pie charts for Income, Expenses, and Cost of Goods Sold. Automatically updates in real-time.