# Splitting amounts **URL:** \ **Category:** Uncategorized\ **Created:** [November 8, 2020, 7:12pm UTC](https://forum.manager.io/t/splitting-amounts/31518 "2020-11-08T19:12:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [November 8, 2020, 7:12pm UTC](https://forum.manager.io/t/splitting-amounts/31518/1 "2020-11-08T19:12:43Z")
My heading is probably not very self explaining sorry. Wondering if this can be done directly in manager at the moment I export all reports to excel and split there. But I do a few rental accounts and where husband and wife are joint owners of the building I have to do 2 separate tax returns. So I import their bank statement to manager and code it to the right places. but when I file the tax return I have to split everything 50%. Wondering if there was a way to split the amounts or the best way to do it in manager so maybe the P&L at least has 2 columns for each with 50% split. Hope I have explained this clearly ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [November 8, 2020, 7:32pm UTC](https://forum.manager.io/t/splitting-amounts/31518/2 "2020-11-08T19:32:10Z")
Use tracking codes and enter two lines for each transaction. Use the calculation feature to determine the amount for the first line, then duplicate that for the second. ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [November 8, 2020, 8:05pm UTC](https://forum.manager.io/t/splitting-amounts/31518/3 "2020-11-08T20:05:33Z")
OK thank you 😀 will give it ago I haven’t use the calculated feature yet just 2 questions do I manually duplicate the 2nd line or can this be done automatically and can this be done from bank rules ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [November 8, 2020, 9:43pm UTC](https://forum.manager.io/t/splitting-amounts/31518/4 "2020-11-08T21:43:23Z")
You have to do it manually, so after performing the calculation, just add a line and duplicate the entries in each field. Note that you may have to round the second line so the overall transaction equals what was spent or received. The Guide on calculation is here: [Perform calculations in number fields | Manager](https://www.manager.io/guides/18222). To do this with bank rules, you would need to edit the transactions before clicking the Bulk Update button. But you will have to edit to add the tracking codes anyway, since you cannot currently include tracking codes in bank rules. So do it then. (Coincidentally, there was an article on using Batch Update to add tracking codes in the recent newsletter.) ---
**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\ **Post date:** [November 8, 2020, 10:18pm UTC](https://forum.manager.io/t/splitting-amounts/31518/5 "2020-11-08T22:18:14Z")
Thank you for your help. I think I will stick to my excel spreadsheet as it has VBA to convert the expenses negative numbers to normal numbers and to make 2 columns and split the amounts between the 2 columns at a % I pick. So all I have to do is copy each report from manager to the clipboard and paste into my spreadsheet and click the button which also saves it as the client in the client folder so I have a copy saved for each client. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 2:52pm UTC](https://forum.manager.io/t/splitting-amounts/31518/6 "2023-01-18T14:52:32Z")
Closed on January 18, 2023, 2:52pm UTC