Negative values (supplier credits) when splitting withdrawals

TheAutoSparkyTheAutoSparky Member Posts: 7

In the old Transactions page, I was able to enter a negative value when splitting a withdrawal while reconciling a statement from a supplier.
IE. a credit for a returned item. I don't seem to be able to do that on the new Transactions page.

Comments

  • TheAutoSparkyTheAutoSparky Member Posts: 7

    This is not good. A function that used to work well and now doesn't work. I can't seem to get any help on this either. Vendor credit notes (negative bills) used to come up in the transaction page with ( ) brackets to indicate the negative value. I see that in the new transaction split window, the negative value bills do not appear. This is a major accounting issue, in which I will have to go else where if this is not resolved.

  • JHRED1JHRED1 Member Posts: 14

    @TheAutoSparky Now it's so less intuitive and harder to use and understand for the everyday folk like you and I - its geared more towards bookkeepers and accountants. It seems they are targeting the software that way. I used to reconcile everything online, synced bank statement, uploaded invoices and got through them. Now I have to print out bank statements and manually re-reconcile them. To me this seems pretty backward and just increases my already hefty workload.

    edited April 5, 2019
  • TheAutoSparkyTheAutoSparky Member Posts: 7

    What they had worked, and worked well. I don't understand how you would handle a credit from a supplier any other way than a negative withdrawal. Anything else makes it look like an income which it isn't.

  • TheAutoSparkyTheAutoSparky Member Posts: 7

    I have since learnt that there is an option when categorizing an income, you can choose to apply it as a refund received for a bill. The problem here is, if the credit note is applied to a different pay period (say, the month after the initial invoice), then I cannot reconcile with supplier's statements.

    Previously, I entered supplier's credit notes in as negative bills, then split the withdrawal, which was a payment for a statement for a month, entered negative values for the split where there were credits notes, and applied those transactions to the credit note. Everything lined up. No confusion.

  • JamieDJamieD Administrator Posts: 1,091 admin

    @TheAutoSparky There isn't a real clear cut workaround here for credit notes which is something that we may be looking at adding in the near future... although not ideal, and might not work best with your situation.. you could technically just add a negative invoice for the customer you are working with (although it sounds like you are working with a vendor instead here). If you give provide a bit more feedback on how this feature would benefit you, that would be greatly appreciated.

  • steve3140steve3140 Member Posts: 5

    Hi Jamie,
    What I have been used to with QuickBooks previously is the ability to enter one or more splits with a negative amount.
    e.g. if I am paying a supplier $100, which includes $120 of expenses and a refund of $20 for a product I've returned to them.
    What I have to do at the moment with Wave is enter the transaction as $120 and then do a separate Journal entry for the -$20 amount. Not ideal.
    Steve

  • JamieDJamieD Administrator Posts: 1,091 admin

    Hi @steve3140. Thanks for sharing your current workflow/workaround in Wave. As of right now, there still isn't a way to split an income transaction to contain a negative amount (unless you were accounting for merchant account fees on an invoice that was paid to you). I do, however, appreciate the feedback that you've provided us here to see how we can improve on this feature in the future.

  • TreasurerCMHATreasurerCMHA Member Posts: 1

    I could really do with this too, but with customers. We receive payments from a credit card processor which comprises of refunds and payments all in one combined reconciliation amount weekly. Until this is available as a feature in Wave, I've just taken the one transaction on the bank statement and translated it to two transactions in Wave - one dealing with the refunds and one dealing with the income - both transactions come to the same total as the original bank statement transaction.

    edited July 30, 2019
  • James_HudsonJames_Hudson Administrator Posts: 128 admin

    Hey @TreasurerCMHA , While there isn't away to split transactions between income and expenses, there is a workaround similar to what you're already doing (taking one transaction and entering two in Wave instead) that will allow your bank transactions to reconcile.

    This trick involves recording the component parts of a transaction to a holding account, and then creating a transfer between the holding account and your bank account using the net transaction that is imported by your bank. To do this:

    1. Add a holding account in the Chart of Accounts page
    2. Record all of the component parts of each transaction (income and expense) as individual transactions in the holding account
    3. Categorize the net transaction that is imported from your bank statement to "Transfer from..." and select the holding account that you have created as the account where the funds are coming from.

    This will clear the balance of your holding account, and reflect each income and expense amount in your Profit & Loss Statement. You'll also be able to reconcile your bank statement against Wave's transactions for your bank account 1:1.

    I hope this helps!

Sign In or Register to comment.