QuickBooks Online: Payments

This article will show you how to successfully setup QuickBooks Online and export & publish an invoice to QuickBooks from LMN.

In this article:

Set Up QuickBooks Online

Export Invoices to QuickBooks Online

Export Payments to QuickBooks Online

Set Up QuickBooks Online

Before you can sync over any invoices to QuickBooks Online, you will need to make sure your QuickBooks Online setup is done correctly.

1. In LMN, navigate to QuickBooks > QB Online
2. Sign in with your QuickBooks Online credentials
3. Click the Connect to QuickBooks button. Once you are connected, the QuickBooks Connection Status with say "connected" and show green.
   
4. Next, on the left side menu, select Setup > Link Service Items
5. Click open the Matched Cost Codes tab
   
6. Match your LMN Cost Codes (left) to your QuickBooks Service Items (right), so revenue is properly directed to your Chart of Accounts in QuickBooks.
   For this example, the Maintenance Cost Code in LMN is linked to Grounds Maintenance Service Item in QuickBooks:
   
   Over in LMN, we have generated and published an invoice to a fall cleanup customer for payment. Under # Line Description you can see Fall Clean Up service has a Cost Code of Maintenance with the Rate beside it:
   
7. The only thing left to do is export this invoice to QuickBooks for accounting purposes.

Export Payments to QuickBooks Online

To export your Payments from LMN to QuickBooks Online, follow these setup steps in the guide below.

⚠️ LMN Invoices must be published to QuickBooks first through the LMN Sync tool

1. In LMN, navigate to: QuickBooks > QB Online
2. Enter your LMN login credentials to access the sync tool. 
   ⚠️You will want to ensure your service items, classes (if applicable) customers, and taxes are properly linked in the SETUP section prior to exporting payments to QuickBooks
3. Next, click on Link Payment Method under SETUP. You will want to match any LMN payment method to a QuickBooks payment method prior to publishing payments through the Sync Tool
   ⚠️ Note: Your Payment methods may differ from this example* If you have no LMN Payment Methods created yet, you can manually create them in Settings > Payment Settings (any online payment methods will be automatically added to LMN the first time you receive a payment)
4. Click on the Payments section and click on Payment Settings.
   This section will dictate where your payments in LMN will land in your QuickBooks. From here, select your Default Payment Type, Default Deposit Account and Default A/R Account.
   💡LMN recommends selecting Undeposited Funds as your Default Deposit Account to properly reconcile your deposit in QuickBooks at a later date.✅ Once your payments settings are complete in the QuickBooks Sync tool, they will be saved for future exports. 
5. To export a payment from LMN, navigate to Invoices > Payments. 
6. Click the checkmark to any Pending payments that are listed that you wish to send to QuickBooks.
   
7. Once your payment(s) have been selected, click on the Update Status button and choose Export to QB from the dropdown.
   Once you click Update, the status of the payment(s) will change from Pending to Queued, letting you know that payment(s) has been loaded into the QuickBooks Sync Tool waiting to be published over.
   
8. In the QuickBooks Sync Tool, from the menu, click on Publish Payments to see a full list of all queued payments ready to be published to QuickBooks.
9. Once you have reviewed your list, click Publish to QuickBooks
   
10. The status of this Export will be visible in Status > Job Status. All Processing exports will either appear with the status of Success, and with a failed status of Error. You will receive a log report directly to your email detailing which payments successfully went over and which ones failed.
    
11. Once Payment has been successfully published, the payment will appear under your Customer in QuickBooks Online, marking the invoice as Paid. 
    
12. For more details like QB payment method, deposit account, payment number, click into the payment in QuickBooks to see more.
    
13. Back in LMN, the status of any published payment(s) will change to Exported to QB. This status indicates the payment was successfully sent over to QuickBooks.
    

LMN Payments to QuickBooks Online Video

To view a tutorial about exporting LMN Payments to QuickBooks Online, click HERE

Need more help?  Contact our Support Team by email at lmn-support@granum.com, through Live Chat, or by phone at (888) 347-9864

Signup for our Live Webinars or learn more about attending our in-person Bootcamps HERE