PDA

View Full Version : Help with creating my Financial Statement


BreinLa
02-13-2006, 02:30 PM
I am trying to create the following financial statement:
Revenues
4000-000 Revenue
4000-900 Revenue-Special Sections
4004-000 Color Sales
4004-900 Color Sales Special Sections
4007-000 Subscriptions
4120-000 Sales Discounts
4130-000 Agency Discounts

Total Revenues


Edit Expenses
5105-100 Salaries and Wages Edit
5106-100 Payroll Taxes Edit
5140-100 Contract Labor-Edit
5200-100 Travel Expenses - Edit
5210-100 Meals and Entertainment-Edit
5220-100 Dues and Subscriptions-Edit
6020-100 Employee Benefits-Edit

Total Edit Expenses


Production Expenses
5105-200 Salaries and Wages-Production
5106-200 Payroll Taxes-Production
5200-200 Travel Expenses-Production
5210-200 Meals/Entertainment-Prod.
5220-200 Dues & Subs.-Production
5230-200 Postage/Freight-Prod.
5350-200 Printing - Prod.
6020-200 Employee Benfits-Prod.

Total Production Expenses

Printing Expenses
5350-300 Printing-Printing

Total Printing Expenses

Advertising Expenses
5105-600 Salaries and Wages-Advertising
5106-600 Payroll Tax Advertising
5190-600 Contract Labor Advertising
5200-600 Travel Exp Advertsining
5210-600 Meals and Ent. Advertising
5220-600 Dues and Subs Advertising
5230-600 Postage/Freight Advertising
5350-600 Printing Advertising
5430-600 Telephone (Cell) Advertising
6020-600 Employee Benefits Advertising

Total Advertising Expenses


Total Operating Expenses

Net Income

I have done everything that the help index suggests and still cannot get it to look that way. Any suggestions woiuld be appreciated

biesmann
02-14-2006, 09:11 AM
I've used the standard income statement format and changed each line item to fit my needs. Right click to get the properties and set the range (or individual account) for that line. Under the formatting section, choose "detail" or "summary" (summary requires a test header for the line). Add lines as necessary where you need them. Hope this helps.

This will take a lot of effort, but I'm pleased with my results.

John

BreinLa
02-15-2006, 02:04 PM
Thank you so much John I have just created the financial statement and it looks great. I think I was trying to make it more difficult than it was