Forum Discussion

GalaxyBK's avatar
GalaxyBK
Contributing Cover User
8 months ago
Solved

How to Tell Which Transactions in Bank Feed do not have Job numbers?

New to MYOB Business (just converted from AccountRight). I have lots of existing bank rules which are automatically allocating transactions. These transactions haven't had the Job Number assigned ye...
  • Trevor_Harrison's avatar
    Trevor_Harrison
    8 months ago

    Hi GalaxyBK 

     

    There is no way to visually see if the allocation made via a Rule has a job code attached to it without expanding the detail of the transaction.

     

    If you are dealing with a lot of transactions where only a few are uncoded then you might consider doing it via a report.  There are several which can be used.

     

    1. General Ledger report.  This report does need modification via the 'Customise Button' to add the Job Code column in to the report.

    2. Job Profit and Loss Comparison Report.  For this report use the 'Jobs' button to deselect all the jobs and then use the 'Report Options' to select display transactions without jobs.  The system will produce a profit and loss report showing balances of all accounts which contain transactions which do not have a job allocated to them.  You can then drill down through each account with a balance and see all the transactions that do not have a job code.  These can be edit from here.  The best way to do that is to right click on the hyperlink and select 'Open in New Tab' otherwise you be forever re-running the report.

     

GalaxyBK's avatar
GalaxyBK
Contributing Cover User

Hi Celia

 

I can't see the Job numbers unless I click on each transaction. Was hoping to see which ones at a glance needed attention. Thanks for your assistance.

Trevor_Harrison's avatar
Trevor_Harrison
Super Partner
8 months ago

Hi GalaxyBK 

 

There is no way to visually see if the allocation made via a Rule has a job code attached to it without expanding the detail of the transaction.

 

If you are dealing with a lot of transactions where only a few are uncoded then you might consider doing it via a report.  There are several which can be used.

 

1. General Ledger report.  This report does need modification via the 'Customise Button' to add the Job Code column in to the report.

2. Job Profit and Loss Comparison Report.  For this report use the 'Jobs' button to deselect all the jobs and then use the 'Report Options' to select display transactions without jobs.  The system will produce a profit and loss report showing balances of all accounts which contain transactions which do not have a job allocated to them.  You can then drill down through each account with a balance and see all the transactions that do not have a job code.  These can be edit from here.  The best way to do that is to right click on the hyperlink and select 'Open in New Tab' otherwise you be forever re-running the report.

 

  • GalaxyBK's avatar
    GalaxyBK
    Contributing Cover User
    8 months ago

    Yes, that has been my work around. The Job Exception report isn't displaying any transactions for which I logged a separate post. So, I have customised the GL Report detail to provide me the info.

     

    Thanks for your input.

     

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    8 months ago

    Hi GalaxyBK,

    Thanks for your detailed post and my apologies for the late response. 

    Thank you for the solution Trevor_Harrison. In addition, The Job Exceptions [Cash Transactions] and Job Exceptions [Invoice transactions] reports, found in the Reports >> Accounts >> Jobs section, highlight transactions without assigned job details.
     

    However, it's important to note that these reports don't encompass payroll transactions. In such cases, I recommend running the General Ledger [Detail] report (Reports >> Accounts >> Accounts) for the specific account and date range. This report will display the Job No. associated with each transaction. If the Job No. field is blank, it indicates that no job has been assigned to that transaction.

    Feel free to post again, we're happy to help!
    Regards,
    Earl