I download my bank csv file and then edit it to give me the columns
Date/Reference/Payee/Description/Amount
Some transactions cover more than one category so I need to split the transaction so that the correct bank rules will apply. On receipts (or positive amounts) this works and the CSV file is accepted and the split transaction appears ready to be posted.
If I try to do the same thing with a payment the CSV file gets accepted but only one of the split transactions gets posted and the bank balance ends up wrong. I then have to wipe all the transactions go back to the CSV file amend the payments back to one transaction and then it gets processed and the bank balance is correct. This then means that I then have to go in and post the corrections in Manager and ignore the bank rules.
This happens when I have splits on receipts and payments at the same time but Manager will always accept the receipt split.
Am I doing something wrong or is there a glitch in the program?
Also whatever I post in the Payee column ends up being tagged onto the end of the description and does not show as a separate item. No big deal as payee normally gets caught on by bank rules but why would it do this?
Bank rules can split transactions, but bank import per se can not in Manager
What kind of split are you talking about during import? Can you be more specific? Are these some kind of bank fees?
On purchases we will pay an invoice to our Football Association for registration fees which will include both seniors and juniors but needs to be split to separate accounts so we can see what we are spending on each category.
On our eftpos account we will get one charge for the day via the bank which can include bar sales (admin), member fees (senior and junior) merchandise sales, events.
The eftpos split I make on the CSV gets accepted but the Football Assoc. one will not.
Other examples of a purchase split would be a Costco purchase which might be split to bar stock, canteen stock and game day food (allocated out per team to feed opponents after a game). Again that split will not go through via the CSV.
Importing bank transactions does not support splitting. The reason is that importing bank transactions is meant to be importing whole amounts on your bank statements only. Then they can get automatically categorized (or split) using bank rules.
If you know the splits during the import, you can use Batch Update which does support splitting.
I hear what you are saying but what you don’t address is why your program happily accepts the splits on receipts but not on purchases.
I have just had a thought in that the receipt splits are generally for eftpos transactions where no invoice number is quoted in the reference but an invoice number is quoted in the payments. Would your program only accept one of the payments with that invoice number and ignore the others?
Finally no one has addressed why the payee ends up getting tacked onto the end of the decription.
I’m not aware of that. The program will not create split receipts by merely importing bank statement in CSV format. You can show sample CSV file you are importing that you claim will create split receipt.
It’s mostly because of the lowest common denominator. Bank statements are in many different formats containing variety of information. So Manager just joins all this information into description. You can use bank rules to automatically categorize imported transactions (including specifying payee).
Just importing payee into its separate field as a text would not be all that useful anyway. Typically you want the payee to be linked to an actual customer, supplier or employee you have already created in Manager.
Decided to do a small test and this was the data that I used which comes from the bank statement that I will process this month. As you can see I have split the bank amounts depending on categories and then posted them to Manager. Manager handled the receipts perfectly but I was very surprised by the results on the payments. Manager did in fact accept both transactions but instead of posting the $600 from the amount column it posted $649.39 from the debit column and posted the $49.39 for the other split effectively overstating the payment total and that was repeated in the other transaction where it posted $1500 from the debit column instead of $1000 from the amount column.
I then wiped all the transactions from Manager and deleted the debit and credit columns and repeated the exercise which all went through correctly.
As far as the Payee is concerned the Club business is run entirely in cash so we do not have customers or suppliers and do not have employees as it is run on a volunteer basis. The payee column is the only way we identify who is involved. Under the bank rules we can identify alot of the payee as a lot of what we do is repetitive with the same organisations.
Finally for a point of clarity all transactions are cash based and manager is being run on desktop via a mac.
You should either have Amount with + and - amounts or Debit and Credit. Thus not both. So delete the Amount column before import and it should be fine.
I flagged your post because it is not allowed to post PDF files, just post a screenshot and remove the PDF file.
@baldi, your post was edited to remove the PDF link, which is a security risk to other users.