If you are looking to simply connect your Square account with Kashoo, please click here to learn how.

Square Account Mapping Setup

While all your import dates and customer, account and tax settings can be automatically created when you connect Square to Kashoo, you can also fine tune these settings. You'll have the following general options to configure:

  • Start Date: Choose what date you want to start importing transactions from. By default it's set to import one year's worth of transactions.

  • Square Customer: Choose the customer name that you want to associate all sales to. By default sales will be attributed to a newly created Square Customer.

Square Payment Type Account Mappings

By default, Credit Card transactions, which are done through Square credit card processing system, are attributed to a Square Clearing account. But what is the Square Clearing account? Well, whenever you make a credit card sale in Square, it takes a few days for the funds to be deposited into your bank account. That Square Clearing account acts as a holding account that represents all the credit card funds that are waiting to deposited into your bank account. Once funds are transferred to your bank account, you will need to transfer your funds from the Square Clearing account into your final settlement account (i.e. your bank account).

Choose what payments types will be attributed to which Kashoo accounts.

  • Bank Account: By default, a Square Clearing account is created in Kashoo. This is where the funds from a Transfer Settlement are temporarily held before being deposited into your bank account.

  • Cash: By default, this is your Cash account. These are any sales that are paid for using cold, hard cash. If you deposit any cash into your bank account, please be aware that in Kashoo you need to create a transfer, moving funds from your Cash account into your bank account. For more info on transfers in Kashoo, please read the article called Using the Transfers Page.

  • Credit Card: By default, the Square Clearing account is used. This is where the funds from a Transfer Settlement are temporarily held before being deposited into your bank account.

  • External: By default this is your Square Clearing account.

  • Third Party Credit Card: By default this is your Undeposited Funds account. These are any credit card sales that are processed using a non-Square payment processing system (like if you accepted a payment via PayPal).

  • Square Wallet: By default this is your Undeposited Funds account.

  • Square Merchant Fees: By default, a Merchant Fees account is created in Kashoo. This is an expense account that tracks the fees you pay to Square for processing credit cards.

  • Unknown: By default this is your Undeposited Funds account. This is used when the payment type is unknown.

You may have noticed that by default, the Undeposited Funds account is used a lot. What is the Undeposited Funds account? Like the Square Clearing account, it is used to temporarily hold money until it is deposited into your bank account. So if you received checks, they would be considered an Other payment type and go into your Undeposited Funds account in Kashoo. Once you deposit them into your bank account, you would need to go into Kashoo and manually transfer the funds from the Undeposited Funds account into your bank account. To learn more about the use of an Undeposited Funds account, please read the following article titled Using an Undeposited Funds Account.

Other Square Account Mappings

Choose which accounts to map things like income, tips, and discounts to.

  • Sales Account: By default this is your Sales Income account. If you enter a custom $ amount that hasn't been mapped yet, sales will be attributed to this account.

  • Tips: By default, a Tips (Income) account is created when you enable the integration. Depending on how you want to handle tips, you may need to use an account type other than income account. If you don't know what to do, we recommend talking with your accountant.

  • Discounts: By default this is your Sales Income account. If you want to track discounts separately, then choose a different account, but it's not necessary to.

  • Rounding: By default this is your Sales Income account. Rounding is used when a sales is rounded up or down by a penny and causes a discrepancy.

  • Other: By default this is your Other Income account. This is for all other payment types.

Square Fees Mapping

Taxes in Square will be automatically created in Kashoo. However, you have the option to map a Square Tax to an existing tax in Kashoo.

If the same taxes don't exist in Kashoo, you can use the Import fee from Square...  option.

Make Sure to Save!

Make sure to click on Save Square when you're done adjusting your settings.

Dealing With Duplicate Transactions

If you manually enter a customer invoice into Kashoo, and then you customer pays through Square Register, you'll end up with a duplicate transaction. This is because in addition to the unpaid invoice you created in Kashoo, the Square integration will import a paid invoice.

There are two ways to correct this:

  1. Remove the unpaid invoice that you manually entered. There are two negative aspects to this method. First, if you're practicing accrual accounting, this can cause your invoice date to be incorrect, as the Square integration only imports invoices once they're paid. So, if you had invoiced a customer in 2015, but weren't paid until 2016, removing the unpaid invoice will artificially lower your 2015 income. If you had filed any taxes based on your 2015 numbers and then deleted the invoice, this would cause your filing to be incorrect. Second, by removing the original invoice you entered into Kashoo, this may cause confusion if you ever try to look up the invoice by its number.

  2. Remove the paid invoice imported through the Square integration. The downside to this approach, is that you need to manually record the payment and Square fees on the unpaid invoice.

Either method is acceptable, but you'll generally run into less issues by following the second way (which is to delete the imported paid invoice and manually record the payments and Square fees for the unpaid invoice).

Did this answer your question?