Transactions without an assigned job number

Thanks everyone. The solution I used was to produce a transaction list of all transactions for the year. Then export to excel. Then sort by account number and job number. This highlighted the transactions affecting the P&L which did not have job numbers assigned. Incidentally the transactions all related to freight collected or freight paid. These are account numbers are generated when you process a sale or a purchase. Myob AR does not currently give you the option to assign a job number to these transactions when they are initially processed. Perhaps that is a fix the MYOB IT area can look at.
Regards
Mike

Hi MichaelChalk,

Thanks for reaching out. AccountRight has built-in Job Exceptions reports that can help identify transactions entered without a job number. For a report specifically showing transactions that affect the P&L but don’t have a job number, you may need to run other account reports and compare the results with the Job Exceptions report to pinpoint the relevant transactions.

Cheers,

Princess

Hi MichaelChalk​ - thanks for the question.

Yes, AccountRight has reports that can help with this:

• Job Exceptions - Cash Transactions lists Spend Money, Receive Money, Inventory and General Journal transaction lines that don’t have a job number.
• Job Exceptions - Invoice Transactions lists sales and purchase transactions that don’t have a job number.

Run both reports for the date range you need. To focus on transactions affecting your P&L, use the report options to exclude balance sheet accounts, if that option is available. You can also export the reports to Excel and filter by the relevant income, cost of sales and expense accounts.

You’ll find these reports under Reports > Index to Reports > Jobs.

If you’re using AccountRight in a web browser and the cash transactions report is blank, try running it in the AccountRight desktop app instead.

For future transactions, you can also turn on the AccountRight preference to warn when jobs aren’t assigned to transactions (Setup menu > Preferences > System tab > Warn if Jobs Are Not Assigned to All Transactions.

I hope this helps!

Adrian