Skip to content
logo Knowledgebase
Page Language

Revenue/Expense Account not Displaying on Project Income Report

Created on  | Last modified on 

Summary

The article provides a guide on fixing missing accounts in Sage 50's Project Income report using four methods: First, ensure 'Allow Project Allocation' is enabled in account settings. Second, link the correct revenue and expense accounts in the Inventory & Service module. Third, in the Project module, adjust purchase or sales invoices to align with the correct project and account. Fourth, for general journal entries, use the Project module to adjust transactions, ensuring the correct allocation of debit and credit accounts to the project.

Cause

  • Project allocation is not selected for the revenue or expense account
  • If revenue account not displaying you have to have a recorded expense for the project
  • Inventory/Service item does not have the appropriate revenue account linked
  • Customer did not select the appropriate project on transaction/invoice
  • Customer did not select the appropriate account on transaction/invoice


Resolution

Method 1: Project Allocation Settings

Method 2: Linking Accounts in Inventory

  • Go to the Inventory &Service module
  • Open the Inventory Record
  • Go to the Linked tab
  • Select the appropriate Revenue and Expense account

Method 3: Adjusting Invoices in Project Module

  • In the Project module open the purchase/sales invoice window
    • Note: If adjusting a manual general journal entry proceed to Method 4
  • Lookup and adjust transaction by selecting Sales/purchases at the top of the transaction window
  • Select Adjust Invoice and double-click on desired invoice
  • Verify that details are correct
  • Verify that the correct account is defined in the account column by clicking on the magnifying glass icon
  • Verify that the project is defined by clicking on the blue check mark in the project column

Method 4: Adjusting General Journal Entries

  • In the Project module open the general journal transaction window
  • Click on Entry at the top of the transaction window
  • Select Adjust Transaction double-click on desired transaction
  • Verify that the transaction details are correct and that appropriate Debit and Credit accounts are defined
  • Press Ctrl + Shift+A or allocate column to allocate entry
    • Note: If you allocating the entire transaction to the same project you can select the option apply this allocation to the entire transaction. If not make sure to allocate each line