Cash payments journal for all purchases the business has made using cash.
Graham Taylor Automotives
Member Posts: 41 Novice Member
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.
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.
0
Comments
-
Try a General Ledger report and then filter or call me on 02668340831
-
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"
0 -
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.0 -
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.
GT0 -
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.
GT0 -
Hi Charles,
Thank you for you time both answering this and yesterday's conversation. Your assistance with this is very helpful and appreciated.
GT1
Categories
- All Categories
- 6.6K Accounts Hosted
- 15 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll 🚀
- 32 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 24 Reckon Mate App
- 2.6K Reckon One
- 8 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 67 About Reckon Community