konmanos's avatar
konmanos
Trusted User
11 years ago
Status:
Done

Get Statement: Allocate multiple lines using Add Transaction

When importing a statement from the bank - or - from the PayPal site, we find that we have many items - eg PayPal fees that we need to reconcile on a per transaction basis. This forces us to select each item - PayPal fee - assign it to the Expense Account - PayPal fee and then do the same again - for the next item - again PayPal fee. The same happens when you receive income - PayPal sale.

 

So if we have 300 sales in a month - we have to select each sale - and assign it to the Sales account - around 900 mouse clicks - 1 mouse click to select the Sale, 1 mouse click to assign the sale to the sales account, 1 mouse click to complete the assignment - total number of clicks 3 - for the 1 x sale. 

 

As each sale - has a PayPal fee - the same number of clicks - 900 - needs to be made for the PayPal fee incurred for the sale. So for the month you will incur 1800 - mouse clicks to complete my reconciliation for PayPal.

 

What would be ideal - is to be able to flag all of my PayPal fees - 300 - with one click at the top of the screen, and assign them all to the PayPal expense account - 2 clicks and complete.

 

The same to occur - when PayPal sales - 300 of these - one click to select them all - and a second click to assign them to the Sales - Online - account. 

 

4 clicks and I am reconciled..

 

Makes better sense to me..

 

"Multiple Expense or Income items - Reconciliation"

7 Comments

  • Suja_P's avatar
    Suja_P
    Former Staff
    Status changed:
    New
    to
    Open
    Thank you for the post @konmanos. It would be great to be able to select multiple lines on the imported bank statement to create one bulk transaction in the system. So that this may be changed in a future update, we request others who would like this change to please vote and comment.
  • I agree with the bulk posting facility in the reconcile accounts for those accounts which don't have any Bank Feeds set up.  There are many accounts & credit cards which don't have the option to link via Bank Feeds.  The bulk posting facility will help with speeding up the bank reconciliation process of these accounts.  

     

    It would be great if Paypal had a bank feed functionality so that you could set up a rule for these to be automatically processed.

     

    The other option is to set up a rule funtion within the 'Get Statment' option of the bank rec.  I know this is possible as it is already in the AccountEdge version, and it has sped up the bank rec process significantly for my Apple clients.  

  •  Hi interAccounts 

    Thank you for your feedback and voting for this idea on the AccountRight Idea Exchange. i have shared your comments with the team.

  • Status changed:
    Open
    to
    Done

    Hi Everyone

    Using the Import Statement function in the AccountRight Browser interface will import the transactions into the Bank transactions window. From within this window, you can bulk allocate the banking transactions.