Split a transaction which is part income and part expense
Help please! Not sure if anyone has a solution to my problem - I run a B&B on my own and am both disorganised and short of time. I run my accounts mostly by whizzing through downloaded bank statements and sorting into different accounts from there. I don't do invoices as I just take payment as people leave, so I record payments as sales receipts as they appear in my bank statements. Great for saving time. However, I now use a small card machine - sumup - which transfers the funds after deducting the transaction fee. If I just record this as income it's not a true indication of what I earned, as it's without the bank fee. But I don't know how to most simply and efficiently manage the real income (eg £70 for a night stay) against the £68 that comes into my account, with the fee deducted - one being income, one being expense. I tried splitting the transaction to manually add the fee deducted, but I can't have both income and expense in a split in one transaction. It's complicated further if it's several people's payments bundled in together... I'm going in circles trying to avoid too complicated inputting and reconciling, as knowing how things get here it's likely things will fall through the cracks or not be reconcilable! I thought about manually inputting expected income, but then I can't match it to the amounts that come in, which will be without the fee. Do I have to manually record the extra income for each transaction and go in and type the £2 extra that was deducted???? That seems so incredibly painful. Does anyone out there have a similar problem that they've found a neat solution to??? Because I'm a novice if I start experimenting I tie myself in knots and make an awful mess of my accounts. Many thanks, in hope.
