Our accountant is looking for a straightforward report that will show "job billing and job cost detail, calculated using an "as of" date. Please help!

Thanks so much,
Karen

Hi Karen

Help me - I can't picture what such a report would look like. I can only say that most accountants use the Jobs in Progress Report to tie to the GL WIP and the GL Billings account.

Although you can't run the report "as of", what you can do in JobCosting is to open and close periods. You should check off the setting in Edit Company Profile | Options to "Warn on invalid entry periods". Then in Edit | Entry Periods close any "future" periods (ie ones you haven't printed financial statements for), opening the next period once your GL is closed for the current month. Doing this your JC data will always be in synch with your GL, the Jobs in Progress Report will tie to the GL balances above, and all of the other reports will be "as of" the last open period.

This doesn't really help you "as of" this moment, but is the proper approach to use in the future.

Steve Schwartz

Hi Steve,

Thank you so much for responding! Jobs in Progress Report is what we want - We closed JC for Sept., Oct., Nov. and Dec. Reprinted Jobs in progress report...no change for August. What should change doing it the way you suggest?

Karen

The company uses only billings & costs revenue recognition.
The accountant wants to see billings compared to costs for jobs as of the end of a previous period.
He sees that for the period costs were high but revenue recognition was low, and assumes, correctly, that for some jobs there were costs posted but billings were not done. Now he wants to see those jobs and the cost & billing details for them.

Karen had created a GV report of the summary costs and billings. I limited it to the most recent two periods and added a linked report of the transaction details with calculated columns to separate billings from costs (and ignore tax & other charges), and with a query for starting and ending dates.

I've been looking for a reference that shows what the numeric transaction codes mean.
I believe 1 is billings, 2 is payments, 3 is other costs, 5 is costs, 8 is retainage.

I hope someone can clarify for me.

1 BILLINGS
2 PAYMENT
3 RETAINAGE (Billings)
4 RETN INV (Billings)
5 COST
6 RETAINAGE (Cost)
7 RETN INV (Cost)
8 OTHER CHGS

The 'Translated coded field' option on the GridView definition should be doing this code translation for you but isn't. The dictionary should be updated by Softrak.

Thank you so much!