What I’m doing at the moment is changing how the membership renewals work. Previously, memberships with renewal type set to “Automatic” had new membership records created automatically when they expired, but these new memberships weren’t linked to orders or payments, and no emails or delivery documents where generated. I’m changing this so that if the information exists, an automatically renewed membership actually goes through the order process and sells a new membership to the customer. This then means that there are proper records for accounts to reconcile against membership income.
Plan A is to have the new membership use the same delivery method and payment type as the original, which will be find if the original order was marked as pay by Standing Order / deliver by post. But it means that if the original membership was bought for cash over the counter, and then manually changed to autorenew, the renewal order will also be logged to cash. The alternative, I suppose, is to leave Direct Debit and Standing Order alone but change all other payment types to a default.