cancel
Showing results for 
Search instead for 
Did you mean: 
elpaso2020
Level 1

Manually Record Square Payments Desktop (NOT Online)

Hello everyone,

Our headquarters has Quickbooks accounts for our various churches located throughout the country. All of us are on the Desktop Enterprise version.  Here at our individual church, we have a bookstore.  We are getting Square up and running and I am trying to find the easiest way to manually enter the Square transactions into QB.  Because we are Desktop, we cannot use the "Sync with Square App". Additionally, because we have multiple locations throughout the country linked to the one account at our headquarters, I cannot try to add any apps in my desktop -- none of us on a local level can to into "App Management" nor "Manage Web Apps" : we are locked out from that ability.  So I need to do this manually & was hoping someone familiar with both Square and Desktop QB could help.  Thank you!

3 Comments 3
ErwinQ
QuickBooks Team

Manually Record Square Payments Desktop (NOT Online)

Hello there, @elpaso2020. Allow me to provide information on how you can record your transaction in QuickBooks Desktop.

 

Depending on how you receive transactions from your Square app in QuickBooks Desktop, you can create invoices, receive payments, make deposits, and match them.

To account for the multiple locations, you need to use class by tracking.

 

You can record your Square app payments as deposits in QuickBooks Desktop. Additionally, you can utilize the class tracking feature to allocate to different locations.

 

Here's how to create a class:

 

  1. Open your QuickBooks Desktop Account.
  2. Go to List.
  3. Select Class List.
  4. Under Name, create locations.

 

I've added  screenshots for better reference:

 

image_720.png

image_720.png

Additionally, you can check this out to learn more about Account Receivable.

 

If you have more questions about managing your transaction in QBDT, feel free to reply. I'm always here to help.

elpaso2020
Level 1

Manually Record Square Payments Desktop (NOT Online)

Thank you for your reply however this does not help with our problem. 

I know how to do classes and I know how to do a deposit. 

I'm trying to find the best, most efficient way of recording the inventory sold with our Square register in Quickbooks Desktop since there seems to be no integration system outside of the Square Synch app for Quickbooks Online.

This reply doesn't address the help needed with recording the inventory sold. 

RheaMaeH
QuickBooks Team

Manually Record Square Payments Desktop (NOT Online)

I appreciate you for coming back to this thread, elpaso2020. I'm here to help you import your transactions from Square to QuickBooks Desktop (QBDT).

 

To begin with, you can use Intuit Interchange Format (.IIF) files to import your payment and sales transactions to and from QuickBooks Desktop. You must sign in to your company file as an admin. If you’re in Multi-user mode, go to the File menu and select Switch to Single-user Mode.

 

Here's how to import transactions using the IIF file:

 

  1. Navigate to the File menu and select Utilities.
  2. Click on Import, then choose Import IIF.
  3. Select the IIF file you want to import and then click Open.
  4. Tap OK to confirm the import.

 

Please note that you must use the correct format and back up your company file before you import IIF files. If any problems occur, you can use your backup to restore your data.

 

Alternatively, you can use file formats like MS Excel and CSV to import your transactions into QBDT. The data you enter varies depending on whichever you use. For more details about importing data, please refer to this article: Import and export data in QuickBooks Desktop.

 

For future reference, you can check this article to learn how to add and match Bank Feeds transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Please let me know in the comments below if you have further concerns about importing your transaction into QBDT. I'll be around to help. Take care and stay safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us