Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
jheselius
July 17, 2021
Question

EXPORT PAYROLL TO DESKTOP MAC

  • July 17, 2021
  • 65 replies
  • 124 views
How do I export from online payroll to Mac desktop into my check register. It was very easy until I started using the new version. I can export payroll taxes easy but not the employee check into.

    65 replies

    Rubielyn_J
    Rubielyn_J
    Level 8
    July 17, 2021

    I'm here to ensure you're able to export employee checks from QuickBooks Online to Desktop for Mac, @jheselius.

     

    In preparing your transactions in a spreadsheet file, make sure that the items on it match the template on QuickBooks. This way, you'll be able to export them successfully.

     

    To do this, here's how:

     

    1. Go to the File menu, then choose Import.
    2. Select Transactions and the transaction type you want to import.
    3. Choose the gear menu, then click Export Table Template.
    4. Enter a name, then save the template. This downloads the template in a .CSV (spreadsheet) file.
    5. Open the template on your spreadsheet application. 
    6. Attach your transactions to the template, then save your work.

     

    When you’re ready, here’s how to import your transactions.

     

    1. Open your spreadsheet file.
    2. In QuickBooks, go to File, then select Import.
    3. Choose Transactions, then the transaction type you want to import.
    4. Copy the transactions from your spreadsheet and paste them on the import window. 
    5. If everything looks right, click Import.

     

    If the same thing happens, you can use an IIF file as another option. 

     

    1. Go to the QuickBooks payroll website. 
    2. Choose the employees and then the paycheck list. 
    3. Click on the box to the left of the paycheck you want to export.
    4. Look for 3 boxes Print/Export to Accounting/Void. 
    5. Click Export to Accounting.

     

    For more insights, feel free to review this article: Import data into QuickBooks for Mac.

     

    Can I also ask if you encounter an error message when trying to export transactions from Online to Desktop for Mac? I appreciate any extra information you can give and it will help me isolate the issue and provide the best solution.

     

    Additionally, let me share this resource to guide you fix some issues in exporting data: QuickBooks Desktop export troubleshooting (Mac, IIF, & One-Click).

     

    Keep me posted if you have other concerns managing your data in QuickBooks. I'll be more than happy to help you further. Have a wonderful day!

    D
    deeba
    October 8, 2021

    there is NO option to export in my system.  this is really screwing up my books, as it says it exported and it did not.

    MJoy_D
    MJoy_DQuickBooks Team
    QuickBooks Team
    October 12, 2021

    Ok.  HELP.  I had the same problem as everyone else.  I used to use Intuit Payroll.  It was seamless with my Mac desktop quickbooks.  I exported 22! transactions today from Quickbooks Payroll.  I have no idea where those transactions are now at.  We literally can not find them (and yes, I looked in my downloads folder).   I spent 3 hours with technical support today.  No help at all.  What a mess.  Basically, the tech support guy told me to type in the transactions manually going forward.  

     

    How can I locate these downloaded transactions?  they are lost! 

     

    David


    I can help you with locating these import transactions in your QuickBooks Desktop for Mac, @dhgibel.

     

    You can go to your Transaction Center to look for your transactions. 

     

    Follow the steps below:

     

    1. Select Transaction Center from the Company menu.
    2. Choose a transaction type.
    3. Enter any information about your transaction in the search box. Names, dates, and amounts can either be used.

     

    Refer to this article for more information to use your income and expense trackers to locate your transactions: View and edit transactions in QuickBooks Desktop for Mac.

     

    To guide you or verify what happens to your transactions once imported to QuickBooks Desktop for Mac, refer to this article: Export Intuit Online Payroll transactions to QuickBooks for Windows or Mac (IIF).

     

    Please refer to the following article for further information on what lists and transaction types you can import into QuickBooks: Import and export data.

     

    If you have any additional payroll concerns, please leave them in the comments section below. I'd be delighted to assist. Take care and have a wonderful rest of your day!

    Rubielyn_J
    Rubielyn_J
    Level 8
    July 18, 2021

    Hi, @jheselius.

     

    Hope you’re doing great. I wanted to see how everything is going about exporting the employee check concern you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

     

    Looking forward to your reply. Have a pleasant day ahead!

    J
    jheseliusAuthor
    July 19, 2021

    Thanks

     

    Could not export form Intuit online payroll into Quickbooks desk top. We hit the 14500 limit. We started merging names and can now export payroll as before.

    L
    lin_jcaj
    Level 9
    July 19, 2021

    It's good to have you back here, jheselius.

     

    I'm glad to hear that merging the names helps you get back on track with exporting your payroll. The information you've shared will surely help other users having the same issue.

     

    If you have any other concerns or questions, feel free to drop a comment below. The Community is always here to help.

    C
    Chelsea123
    January 16, 2023

    Hi, Im not an accountant, I am a business owner of 30 years. I am a plastering contractor about to throw in the towel because Quickbooks stopped syncing checks written to my men into my quickbooks for Mac. I since have migrated my desktop to my online payroll, but the new platform is not so simple for me. I just want the bank transactions to show up in my desktop for Mac like they used to do. but since I purchased the online payroll six months ago the syncing stopped and I had to manually enter in every transaction painstakingly. Can you help me sync my desktop for Mac to my bank accounts?

    MJoy_D
    MJoy_DQuickBooks Team
    QuickBooks Team
    January 16, 2023

    I can guide you with fixing the issue you're having to sync your bank transactions to your QuickBooks Desktop for Mac, @Chelsea123.

     

    First, make sure that you have the latest release for your QuickBooks Desktop for Mac. You can install the update from the QuickBooks menu. Check this article for detailed guidance: Update QuickBooks Desktop to the latest release. Then, create a backup of your QuickBooks company file to use the file in case you run into some problems. 

     

    Once done, make sure the financial institutions' list is up-to-date. You can do it by deleting the fidir.txt file from the Library or Applications. See this article for detailed guidance: Fix online banking issues in QuickBooks Desktop for Mac. You can also follow the next solutions provided in this article if the first one didn't work. 

     

    After downloading transactions from your bank and you already have similar entries in your register, here's how you can add and match those transactions to avoid duplicates: Add and match transactions in QuickBooks Desktop for Mac.

     

    Let me know if you need further help with syncing your bank and QuickBooks. I'm here to assist. Have a wonderful day!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement