import rules for transfers

Drats - I have an awful lot of these! This explains why I couldn't work it out!.

Belated thanks for the answer

Natasha

Well, you can technically mass update transfers but they end up as REC/PAY transactions instead of transfers. The end goal is the same but your sales and purchase list will get clogged right up.

Hi Natasha, I'm just going to link our Support Guide on performing a mass update in case you choose to act on Kevin's suggestion.

https://www.clearbooks.co.uk/support/guides/explain/mass-update/

Thanks,

I use the mass update for other recurring transactions. I have been wondering about setting up an account code just for transfers and excluding it from the VAT return. (Our credit card payments go into one account then get transferred to our main account everynight, the same happens to cash takings so we are dealing with several repeatable transactions a day)

If I set up a discrete code (or one for cc and one for cash):-

• the net result in that code will be zero as equal amounts go in and out
• I should be able to filter it out of reports etc

Im behind on accounts at the moment due to several disasters in the last yr (baby, illness and flooding) so Ive decided to plod through for now and give it a whirl from the new financial year - so if it goes horribly wrong I have time on my side to put it right!

Thanks for your suggestions

Natasha

Hi Natasha,

If you were to create an account like that the net balance would indeed generally be zero, but as for it not showing up on reports that depends on what sort of reports you mean. Reports such as, for example, the balance sheet or the P&L will show every account with a relevant account code which have had transactions on them. Specific codes cannot be excluded as that would (in principle) make the report inaccurate.

It's been a long day but I'm lost in all honesty. What are you trying to achieve with this new account code?

This feature was implemented a while ago now. You can save all matches (bulk update) using a bank transfer import rule, from the transfer tab when explaining a transaction.