Support » Plugin: Sprout Invoices - Client Invoicing & Estimates / Quotes » Mass import of invoices: taxes treated as discounts!

  • Resolved songdove

    (@songdove)


    I am preparing to move my invoicing from Freshbooks. I did a mass import and discovered that all my 5% GST amounts are being deducted as discounts in the percent column. Is there is a mass way to fix this before I alert my clients to the move? ALL invoices are incorrectly lower than they should be. I need a way to fix this en-mass as I have over 1000 invoices to go through.

Viewing 15 replies - 1 through 15 (of 24 total)
  • Plugin Author Dan Cameron

    (@dancameron)

    Hello,

    The easiest way to do this is kill all the SI records and do another import. This time adding a negative sign (to the discount column), e.g. “-5”.

    I’m assuming you used the discount column for the line items. Maybe you can provide an example if that doesn’t help.

    Regards,

    songdove

    (@songdove)

    Freshbooks does the line-item thing, yes. Now to find where to change the discount field to a negative before doing my next import. I deleted all the invoices fine.

    Plugin Author Dan Cameron

    (@dancameron)

    Are you using the freshbooks import, or the CSV method?

    songdove

    (@songdove)

    I’m using the Freshbooks import.

    songdove

    (@songdove)

    I can create a line-by-line csv from the freshbooks invoice details report, but it looks like I’d have to go year by year or even less with over 729 invoices’ worth of line-items to go through since 2010. That report does give me the discount field however. Canadian accounting rules require me to keep financial records back at least 7 years, up to 10 years in some cases. So I need to take my history with me and it begins on Freshbooks back in 2010.

    Plugin Author Dan Cameron

    (@dancameron)

    Can you provide a screenshot of an example of where the GST is applied? It seems like a custom script it required at this point.

    songdove

    (@songdove)

    Ok, this importing process is going to be a pain no matter which way I slice it.

    Trying to do the CSV thing, and discovered an issue with the field mapping. I use all three phone number fields in Freshbooks, but your example CSV file only contains one telephone field. My invoice report CSV file without editing yet, from freshbooks already contains payments, but your CSV import process has payments being imported separately. I may not have been looking in the right place on the documentation for sprout invoices, but I am wondering how you suggest breaking out that info for importing via CSV.

    Needless to say, I am still hoping there is a quicker fix doing the freshbooks import directly somehow. . .

    songdove

    (@songdove)

    our responses crossed paths, one moment. . .

    songdove

    (@songdove)

    https://www.fa-ct.com/fcswp/stuff/invoiceeditscreen.jpg

    The csv download for something like that looks like this:

    first name last name 13006 2016-02-08 paid 2016-02-10 Software TS entry notes 45 0.81 0 1.8225 0 38.2725 CAD

    songdove

    (@songdove)

    The numbers near the end of that line, the first 0 is in the discount column. The second 0 in the second tax column. The number in between them is my GST.

    Plugin Author Dan Cameron

    (@dancameron)

    Can you share a screenshot of what Sprout Invoices imported?

    songdove

    (@songdove)

    Plugin Author Dan Cameron

    (@dancameron)

    Hello,

    Since this is just standard support I needed to focus on the product development (since there’s going to be a release next week) and priority support. Hope you understand.

    I’m a bit confused, even with the pictures, sorry. I see that the line item totals may be incorrect, I see that the GST checkbox is checked, but I also see that there’s a 5% discount added.

    Is there anything I can do to simply make it work? You mentioned earlier doing a mass update. Would a mass update of line items of a 5% discount to a 5% tax work? Or would it be better to remove the discount and mark each with a GST tax?

    Regards,

    songdove

    (@songdove)

    Hi Dan,

    Yes, standard support takes a back seat to priority releases for sure. That’s part of why I was willing to wait a couple days before inquiring. I will be a paid customer, but need the free version working first.

    A mass update was all I was after. Something that offers a fix for what I already imported, because my tests already show that invoice creation within Sprout calculates things properly. It’s just the imported records that need the update. When I did this manually with one imported invoice, the totals reflected their historical values. I don’t want to manually go through ALL my imported records one by one, line by line. I would just rather run a quick fix that converts the 5% discount to a 5% tax and double-check that GST has been checked. If this can be applied only to imported records, then I know the system will continue to work as designed when I go to create new invoices.

    After that, need to pray for favour when I go to purchase the business package. I am so overdrawn on the credit card it’s not funny.

    Plugin Author Dan Cameron

    (@dancameron)

    Since this is going to require some custom development I’ll put it on my list of things to do this week, hopefully I have some free time to get it done early for you.

Viewing 15 replies - 1 through 15 (of 24 total)
  • You must be logged in to reply to this topic.