Is there any way to stop the Suspense Account from appearing when generating a P&L?
I ask because I am having major problems reconciling sales with monies which come into the live bank feed because we have multiple payment providers dumping aggregate receipts from different days into the live bank feed. It’s near impossible to match/split every single sale to the monies landing into the live bank feed from SagePay and WorldPay - there just isn’t enough time to dedicate to finding every single sale from different channels.
Our individual sales which are recorded every day into old-fashioned sales-receipt books are logged in Quickfile in holding accounts I have set up - one for credit card sales, one for PayPal sales and one for eBay Adyen sales. So one way or the other, everything that comes into the till is recorded and finds its way into the nominal ledger.
Some stuff is easy to reconcile from our live PayPal and bank feeds, but other stuff remains un-tagged and appears in the suspense account which annoyingly slots itself into the P&L. At the moment all my boss is concerned with is looking at a monthly P&L but the inclusion of the suspense account figure is ruining his experience! We’ve not long switched to Quickfile and I’m sure I’ll whittle away at the suspense account entries in time, but for now they are very much unwanted in the P&L list!