Cash payments journal for all purchases the business has made using cash.

Options
Graham Taylor Automotives
Graham Taylor Automotives Member Posts: 41
edited April 2020 in Reckon Accounts (Desktop)
I need a cash payments journal report for all purchases the business has made using cash.

Any ideas on where to find this in 'Reports' or what items of customisation I need to create this report. Currently when I create a report and filter it by 'cash' payment method the report brings up nothing.

I have tried to create this report using 'Transaction list by supplier', 'Suppliers and Payables' and 'Purchases' functions. I have also rung Reckon support who also came up with the same results and could  not assist. Any feedback would be helpful, perhaps a cash payment journal is called something else in Reckon?

Thank you. 

Comments

  • Charley
    Charley Member Posts: 546 ✭✭✭
    edited January 2020
    Options
    Try a General Ledger report and then filter or call me on 0266834083
  • gazza73
    gazza73 Accredited Partner Posts: 803 Accredited Partner Accredited Partner
    edited February 2017
    Options
    GT....
    Your frustration can be put to rest..... The reason your two reports mentioned , are not working,  is because the 'purchases' report is based on supplier BILLS - but you're not entering bills.  And looking a 'payables'  is also pointless,, because you're not raising 'bills' in the first place against a supplier, op there are no 'payables' to look at.

    So, what you need are simply 'transactions' that are made in cash (and not get involved with purchases or suppliers or payables).

    That's where Charle's idea comes in,  dealing purely with the general ledger,

    Gary Pope
    An Accredited Partner- Consultant  (VIC. Aust)

    "Working with Accountants/Bookkeepers PPs/APs, as an
          independent IT Professional
    and retired FCPA Accountant"


  • Kwikbooks (Professional Partner)
    Kwikbooks (Professional Partner) Member Posts: 824 ✭✭✭
    edited April 2020
    Options
    Hi GT

    If you are talking about actual cash, as opposed to coming out of a bank account, then  you would have set up a 'cash' 'paid from cash' or 'petty cash' bank account.  Print a transaction report from this account.
  • Graham Taylor Automotives
    Graham Taylor Automotives Member Posts: 41
    edited September 2016
    Options
    Hi Gary

    These are bills, they are invoices like any other invoice that must be entered as they directly affect our stock levels and these items must be chargeable to a customer.

    The only difference between my bills is the method of payment so they most certainly fall under payables, suppliers etc.

    The GL shows your debtors, if you want to see your creditors you need to specifically use the custom settings to show creditors as well which is not the type of report I need. I have previously tried using the general ledger however it doesn't really matter what report you choose as your custom options are the same. The GL doesn't provide the information or the correct format that I need.

    Thank you for your comment. I appreciate you taking your time to assist with my query.

    GT
  • Graham Taylor Automotives
    Graham Taylor Automotives Member Posts: 41
    edited September 2016
    Options
    Hi,

    Thank you. I think that this is what I am going to have to do. This part of the system appears to never have been set up correctly so I'm not sure how I actually rectify this over all yet but this does seem to be the best option. Its a pity Reckon customer support couldn't tell me this initially. 

    Thank you for your comment, your assistance is appreciated. 

    GT
  • Graham Taylor Automotives
    Graham Taylor Automotives Member Posts: 41
    edited September 2016
    Options
    Hi Charles, 

    Thank you for you time both answering this and yesterday's conversation. Your assistance with this is very helpful and appreciated. 

    GT