Dashboard - Top Customers

Options
Ted_5835084
Ted_5835084 Member Posts: 46
edited July 2019 in Reckon One
The Reckon One Portal can show a Top Customers List.

image

Can someone explain why total amount for Top Customers total does not tally with Top Income total. I can only assume it is because it considers all money into the bank accounts, even that which is not income. ie equity in and so on.    In my example $69756 in income but somehow another ~ $36,000 in money received from customers making it show $105,000 which is wrong.   Is there any way to tell the Top Customers to only consider the income accounts. 

Comments

  • Rav
    Rav Administrator, Reckon Staff Posts: 15,391 Community Manager Community Manager
    edited June 2018
    Options
    In regard to the disparity, is the reporting period for each tile the same? (Click the spanner icon to check)


    ℹ️ Stay up to date with important news & announcements for your Reckon software! Click HERE for more info.

  • Ted_5835084
    Ted_5835084 Member Posts: 46
    edited July 2019
    Options
    Yes they are. All of the Tiles are set to this financial year. 

    image
     

    Top income and Top expense correlate nicely to the Net Position widget at top right. Green arrows.

    Whereas Suppliers and Customers bear no resemblance.  Reckon one seems to force every individual to be a customer or supplier even when they are neither.  So the $11,850 figure beside the second "Customer " (a) is an amount of equity a person who is neither a customer or supplier added to the business.   It was assigned to Sole Trader Contributions which is an Equity account. Likewise the figures in (b) and (c) for All other suppliers and customers no doubt contain predominantly   equity related transactions that have no relationship to real customers or suppliers.

    image

    I think it would be better if the Customer and Supplier reports (be they Tiles or Reports) could be filtered to ignore these Equity type transactions.