Departments and Masking/Financials

[jbooksrv]

I have a new client who has been in business about 6 years. He is using Peachtree Complete 2002.

As of next month, he is adding a division. He has added this division as follows:

Original accounts

Sales 4000
Labor 5000
Purchases 5010

Now his chart of accounts looks like

Sales 4000
Sales - Machine Shop 4000-01
Sales - Assembly 4000-02
Labor 5000
Labor - Machine Shop 5000-01
Labor - Assembly 5000-02

He still uses alot of the original accounts for expenses not specific to a department. The balance sheet accounts have not changed.
I normally do not use Peachtree, but have been asked to set up the following reports.

A consolidated financial
A department 01 financial
A department 02 financial

Any suggestions?

[aljr1]

Peachtree allows for departmental financial statements. You must set up you income and expense account numbers accordingly. It appears you have already done this at least for the income accounts. Based on how you have set up your accounts, if you want a income statement for the machine shop department your mask would be "*****01". The financial report would reflect only the income and expense accounts ending in the departmental suffix of "01". You would create and save other reports for the other departments accordingly. The consolidated report would simply be without any departmental mask

[santafecom2]

I understand you can create individual departmental income statements using the masking feature, but is there a way to keep the departmental information grouped together on the "consolidated" income statement?

For example:

Sales Department
Salary Expense
Postage Expense
Total Sales Expense

Marketing Department
Salary Expense
Postage Expense
Sub-total Marketing Expense

TOTAL EXPENSE

instead of ...

Salary Expense (Sales)
Salary Expense (Marketing)
Postage Expense (Sales)
Postage Expense (Marketing)

TOTAL EXPENSE

[chikamic]

No, this would have to be done through Crystal Reports.

[Robert Walraven]

No, this would have to be done through Crystal Reports.

Or by using PawCom.

[chikamic]

Actually PawCom would really be a better choice since it is easier to learn than Crystal.

Thanks Robert.