Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Importing CM to quickbooks online

  1. #1
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default Importing CM to quickbooks online

    I have been using campground master and QB desktop for years. I switched to quickbooks online which does not support iff format. Is there a way to import my CM into QB online? It does accept CSV format, but I have no idea how the mapping works. There are some third party programs to import iff to QBO but they seem pretty sketchy. Does anyone know of a safe one if that is the only option?

    Thanks

    Scott

  2. #2

    Default

    From what we've seen, the CSV importing to QB online would not support the necessary functionality. So we don't know of any way to import from CM to QB online.
    Stan Spielbusch
    [Forum Administrator]

  3. #3
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default

    Ok, I believe you are correct. I downloaded quickbooks 2019 desktop in an attempt to revert back to a desktop version so I can import. I tranferred my QB online account into it. I then re-exported my iff and re-entered all my mappings. When I brought it in I got the following error message from Quickbooks which happened on all 226 entries as they all have an A/R entry and are split.

    [ERROR] The record at (or starting at) this line could not be imported. There was an error when saving a SalesReceipt. QuickBooks error message: Transaction split lines to accounts receivable must include a customer on that split line. [3180]

    I think this is because CM does not export a customer attached to the AR entries. It appears this new version of quickbooks will not let you import unless there is a customer attached to AR entries. Although it appears Campground Master Sales is that customer which I have setup in Quickbooks.

    Is this the way you see it Stan or am I doing something wrong.
    Last edited by scott mcgourley; 11-09-2018 at 06:55 AM.

  4. #4
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default

    this is a typical daily entry from the IFF file

    !TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5
    !SPL SPLID TRNSTYPE DATE ACCNT NAME MEMO AMOUNT QNTY PRICE INVITEM PAYMETH TAXABLE EXTRA
    !ENDTRNS

    TRNS CASH SALE 1/8/18 Undeposited Funds Campground Master Sales 0.00 N Campground Master Sales
    SPL CASH SALE 1/8/18 Sales-Site Rentals Monthly Rate -9600.00 9600.00 N
    SPL CASH SALE 1/8/18 Undeposited Funds check 45778.98 -45778.98 Check N
    SPL CASH SALE 1/8/18 Accounts Receivable Campground Master Sales A/R balance change (-) -36178.98 36178.98 N
    SPL CASH SALE 1/8/18 Advance Deposits New Deposits to deposit account -2250.00 2250.00 N
    SPL CASH SALE 1/8/18 Advance Deposits Deposits Applied from deposit account (-) 2250.00 -2250.00 N
    ENDTRNS

  5. #5
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default

    I wonder if i just import using general journal entries instead of cash sales if this will circumvent this issue.

    scott

  6. #6

    Default

    We don't recommend using the General Journal entries.

    This is the first I've heard of an error regarding the A/R like you mentioned.

    The IIF you showed does have the customer name in the line, and that's the way Campground Master exports it already.

    One possibility is that when you set up the new QB, the Customer "Campground Master Sales" was not created, or was not created as the correct type of customer. (If it's not there before you import the FIRST time, QB creates it but it's not right).

    I would try deleting that customer from QB, then create a new one (using a different name, and of course change the CM export setup to use the new name).
    Stan Spielbusch
    [Forum Administrator]

  7. #7
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default

    Ok, I did that, but with the same results. It almost seems like it is not picking up on the customer name. Here is the error I got this time. I changed the account to Daily Sales in CM, I made a new customer in QB called Daily Sales and deleted Campground Master Sales. I re exported the IFF from CM and Reimported into QB. Again every line with an A/R entry failed.

    !TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5
    !SPL SPLID TRNSTYPE DATE ACCNT NAME MEMO AMOUNT QNTY PRICE INVITEM PAYMETH TAXABLE EXTRA
    !ENDTRNS
    ; [ERROR] The record at (or starting at) this line could not be imported. There was an error when saving a SalesReceipt. QuickBooks error message: Transaction split lines to accounts receivable must include a customer on that split line. [3180]
    TRNS CASH SALE 1/1/18 Undeposited Funds Daily Sales 0.00 N Daily Sales
    SPL CASH SALE 1/1/18 Sales-Site Rentals site rental -6000.00 6000.00 Y
    SPL CASH SALE 1/1/18 Sales-Site Rentals Seasonal Rentals -501775.00 501775.00 Y
    SPL CASH SALE 1/1/18 Sales late fees -1691.03 1691.03 Y
    SPL CASH SALE 1/1/18 Accounts Receivable Daily Sales A/R balance change (-) 337001.45 -337001.45 N
    SPL CASH SALE 1/1/18 Advance Deposits Deposits Applied from deposit account (-) 172464.58 -172464.58 N
    ENDTRNS


    Any more suggestions? Is it possible this is a QB 2019 issue????

  8. #8

    Default

    This may be an issue with QB 2019. everything looks like it's exporting properly.

    Is there any way you can go back to an older version?
    Stan Spielbusch
    [Forum Administrator]

  9. #9
    Join Date
    Aug 2014
    Location
    new gretna, nj
    Posts
    23

    Default

    I will see if an older version will work. I did import the general journal entries and it worked. Why do you not recommend that method?

  10. #10

    Default

    The General Journal method does not transfer as much information (like "Item" information if you mapped those), and may not result in the same kind of reporting. A/R isn't exported as a separate item -- ALL entries go through A/R as a + or - to A/R. And it's also more difficult to "redo" an export -- have to find and delete each journal entry instead of a single Sales receipt.
    Stan Spielbusch
    [Forum Administrator]

Similar Threads

  1. Trouble importing to Quickbooks
    By Grandcouleerv in forum Technical Support
    Replies: 1
    Last Post: 01-31-2018, 06:39 AM
  2. Quickbooks and mapping
    By Mill Bridge in forum Technical Support
    Replies: 18
    Last Post: 09-05-2017, 09:08 AM
  3. Importing Reserve Right Payments
    By Stewy56 in forum Discussion Board
    Replies: 0
    Last Post: 08-20-2017, 05:05 PM
  4. Quickbooks and CM Deperate for Help!
    By jdkehoe in forum Discussion Board
    Replies: 0
    Last Post: 12-04-2010, 06:00 AM
  5. Exporting to Quickbooks
    By DesertRV in forum Technical Support
    Replies: 1
    Last Post: 09-09-2009, 01:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •