vrrusa13
01-26-2004, 08:30 PM
First -- Long one!!! Sorry -- Thank you all so much from your help! I come here first when I have a questions and always get good info!!
So, it's my turn now -- I am trying to set up a totally new system -- I have run into several problems that are unique to us -- I have Peachtree 8 on win 2000 w/ office 2000 (also sometimes I work on it at home w/ Win98 & Off97)
First -- background:
We are a temporary placement agency so we place temporary employees at differant jobs and have to bill for them and track their costs - there are lots of costs & they are differant at each site and for each temp and for each type of hours (ie, differant bill rate for Regular hrs vs OT) -- I would need to track income & Exp by -- GL acct, Physical location, customer (same co in several states), and the clients PO number? (Ie., IBM in 4 states with 82 POs - I need each state, and location and PO tracked along with the totals for each and for all!)
1) Masking may work -- but what is the max size of the GL field?? Any suggestions on the structure? What should I use AR to track vs Fin Stmts?? Do I make a set of Exp for each income acct??? Any other acct categories I shoud include in the scheme?
2) Clients PO numbers -- How in heavens name can I track the balance of each of their POs and bill against them? Ie., take the IBM example above - how can I bill for each temp on the PO and have it itemize for OT & DT at differant rates for each person??
-- I need to know how much we have billed and when to reup their PO $$ BEFORE they are in the red - Could I would use inventory? But how would I do that since my temps move around and make differant amounts at differant places and we bill differant rates for everything??? Sales orders??? But how to bill differant OT vs Reg $$ when they cannot be specified and change per person on the PO?? (I won't even mention shift pay!!!)
We will be using Paychex Preview to process our payroll (750+ per wk), Thank God!! But I still need to import and bill (using Peachtree as above) from Paychex. Anyone got any ideas on a bridge??
How can I import our customer histories?? all of those invoices and POs are at present in a HUGE spreadsheet that I track manually and it is way way to time consuming and unweildy -- I need to get them into Peachtree but I keep getting the strangest errors (I cannot import the spreadsheet I just exported out of EXACTLY the same place!?!)
I also need to figure out how to reconcile our bank acct and not blow up Peachtree - (I think 3000 checks per mo is more than Peachtree can take!) -- But the AR & AP is relatively (50 checks and 200 invoices per week?) small in comparision??
Lastly, and maybe most importantly, since we have such a tight cash flow (payroll and taxes go out NOW and payment comes back in 15 to 45 days - Ouch!) -- We factor our invoices (sort of take a short term loan out on our A/R) Everything goes through the factoring co. and I need to track it against our invoices AND deduct the charges -- Could I make it a discount kinda thing in the invoice itself?? Suggestions for what account and where in the GL??
I have been puzzling about these things for weeks and my head hurts and my deadline is fast approaching -- I haven't been able to find anyone who can answer these questions and they were not answered elsewhere (I have the manual, & the dummies books, etc...) -- Help!!
Thank you so much!!
So, it's my turn now -- I am trying to set up a totally new system -- I have run into several problems that are unique to us -- I have Peachtree 8 on win 2000 w/ office 2000 (also sometimes I work on it at home w/ Win98 & Off97)
First -- background:
We are a temporary placement agency so we place temporary employees at differant jobs and have to bill for them and track their costs - there are lots of costs & they are differant at each site and for each temp and for each type of hours (ie, differant bill rate for Regular hrs vs OT) -- I would need to track income & Exp by -- GL acct, Physical location, customer (same co in several states), and the clients PO number? (Ie., IBM in 4 states with 82 POs - I need each state, and location and PO tracked along with the totals for each and for all!)
1) Masking may work -- but what is the max size of the GL field?? Any suggestions on the structure? What should I use AR to track vs Fin Stmts?? Do I make a set of Exp for each income acct??? Any other acct categories I shoud include in the scheme?
2) Clients PO numbers -- How in heavens name can I track the balance of each of their POs and bill against them? Ie., take the IBM example above - how can I bill for each temp on the PO and have it itemize for OT & DT at differant rates for each person??
-- I need to know how much we have billed and when to reup their PO $$ BEFORE they are in the red - Could I would use inventory? But how would I do that since my temps move around and make differant amounts at differant places and we bill differant rates for everything??? Sales orders??? But how to bill differant OT vs Reg $$ when they cannot be specified and change per person on the PO?? (I won't even mention shift pay!!!)
We will be using Paychex Preview to process our payroll (750+ per wk), Thank God!! But I still need to import and bill (using Peachtree as above) from Paychex. Anyone got any ideas on a bridge??
How can I import our customer histories?? all of those invoices and POs are at present in a HUGE spreadsheet that I track manually and it is way way to time consuming and unweildy -- I need to get them into Peachtree but I keep getting the strangest errors (I cannot import the spreadsheet I just exported out of EXACTLY the same place!?!)
I also need to figure out how to reconcile our bank acct and not blow up Peachtree - (I think 3000 checks per mo is more than Peachtree can take!) -- But the AR & AP is relatively (50 checks and 200 invoices per week?) small in comparision??
Lastly, and maybe most importantly, since we have such a tight cash flow (payroll and taxes go out NOW and payment comes back in 15 to 45 days - Ouch!) -- We factor our invoices (sort of take a short term loan out on our A/R) Everything goes through the factoring co. and I need to track it against our invoices AND deduct the charges -- Could I make it a discount kinda thing in the invoice itself?? Suggestions for what account and where in the GL??
I have been puzzling about these things for weeks and my head hurts and my deadline is fast approaching -- I haven't been able to find anyone who can answer these questions and they were not answered elsewhere (I have the manual, & the dummies books, etc...) -- Help!!
Thank you so much!!