Transactions not appearing on reports

[NMor91]

Hello,

First of all I should start by saying that I've taken over on Sage 50 from a colleague who recently left. I had a handle on its basic processes before this, but some of it is new to me and I'm not an accountant, so please have patience with me. This could well be a daft error that I've overlooked.

I'm running Sage 50 Accounts Pro ver. 21.5.9.201 on Windows 10 Pro, 64-bit.

I've been working through our books for the end of the quarter and all I have left to do is print the reports. I've been able to print our day books reports for our supplier invoices and payments, and these all seem fine, but when it comes to the day books reports for customer receipts, nominal activity, and the sales receipts/bank receipts by bank, almost nothing appears on the printouts except for a sales receipt related to one retail order - i.e. very small order that was paid up soon after. Looking at our hard copy files of past printouts, I can see that we'd expect to see a handful of SIs and SRs on the big orders from our trade customers, as well as the corresponding contra entries and sales receipts. The customer invoices summary successfully lists all transactions that I'd expect to see, but only the one single sales receipt appears on the other reports, despite the fact that all seem to have been paid off on Sage.

So, at least the day books customers invoices, aged debtors analysis, and customer credits reports all look ok.

When I look at the affected customers' account activity, sales receipts and contra receipts do appear there. I'm printing all reports from the correct bank accounts as far as I can tell. There are no filters on when I try to print.

What might have caused them to be missing from the reports? I'd really appreciate any assistance.

[brucedenney]

Printing reports and wasting paper is a BAD idea.

I suspect that you are running the Receipts against only one bank account, you need to run them for each bank account.

Without seeing the detail it is hard to tell.

[Chellebear]

The reports an accountant will need are:

Trial balance

Profit and loss (brought forward to year end - this picks up any items inadvertently posted for last year, after that year end was run). Go into chart of accounts and double check all codes are picked up before running this.

Nominal activity for the year ( tick to include balance brought forward)

Closing debtors detailed at the year end (leave the start date as year dot and tick exclude later payments)
The same for closing creditors.
You can run both the above as summaries too.

If your banks are balanced, that suggests that the sales receipt has been picked up, and you should see that sales invoice reference on the 4000 code as the net figure. And the VAT should be in the sales tax control account.

You'll also give your VAT return print outs for each quarter. If you are on standard VAT accounting, you could also run a dummy VAT return for the full year (tick include reconciled) and it will give you the years figures in one report. Print summary and detailed but of course, don't reconcile, just close out of it.

I have never used a sales daybooks or the like and you can pass the back up to your accountant, if they have sage, to restore it, so they can use it if they need to.

I export everything as PDF, rather than print. Save a tree (and courier costs!) a pen drive is a you need (or share Dropbox with the accountant)