Question

EXPORT PAYROLL TO DESKTOP MAC

Forum|Forum|5 years ago
July 17, 2021
65 replies
90 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.

QuickBooks Online

Rubielyn_J

Level 8

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:

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

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

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

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

Go to the QuickBooks payroll website.
Choose the employees and then the paycheck list.
Click on the box to the left of the paycheck you want to export.
Look for 3 boxes Print/Export to Accounting/Void.
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

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.

A

Archie_B

Level 6

Hi there, deeba.

Let me help and make sure you locate the file you exported.

Upon exporting your IIF file from QuickBooks Online Payroll, the system will ask you to save your file.

Most of the time the default location for the downloaded files set by your browser is on your Downloads folder. Once you have the file, you may start importing it to QuickBooks for Mac.

Like this:

From QuickBooks Mac, click File.
Choose Import, then From IIF Files.
Locate the IIF file and import it into QuickBooks Mac.
Once done, the payroll information should now appear in QuickBooks Mac.

Exporting your payroll data is a one-time process. If you're still unable to locate exported payroll transactions, I recommend contacting our support team. They can also do secured screen sharing to help locate the file.

Let me know how it goes by clicking the Reply button below. I'll keep an eye for your response. Have a nice day!

Rubielyn_J

Level 8

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

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

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

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

QuickBooks Team

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!

Sign up

Login with SSO

Let's get you signed in

Login with SSO