Springboard Retail offers a real time integration with Quickbooks Online (QBO). See this article for more information on that integration: Integrating Springboard Retail to Your Quickbooks Online (QBO) Acccount.
If you are not using Springboard Retail's QBO integration, you may need accounting reporting to obtain the numbers (for example, debit and credit amounts) that you want to include in the journal entries used in your accounting software. You can easily obtain the required reporting and numbers using Springboard Retail's Reporting feature. Reports can be run on a regular basis (for example for yesterday or last week) and can be printed or exported into excel for ease of use. Reports can also be run by location, should you want to book journal entries at the location level.
So, how can you get to the numbers / reporting you need to book journal entries?
(1) Decide/Confirm Your Desired Journal Entries
We first recommend that you work with your accountant to decide what reports and journal entries you need to create. This list of Springboard Retail financial events may assist with this process:
- POS Ticket (Sale or return of product to/from a customer)
- Sales Invoices (Sale of product via a sales order to/from a customer)
- Vendor Product Receivings or Return (Receipt or return of product from/to a vendor)
- Inventory Adjustments (Adjusting inventory quantities out or in)
- Gift Card Adjustments (Manually adjusing giftcard balances out or in)
- Cash Paid In or Out (Taking cash in or out of a drawer for reasons other than a POS ticket, for example - to purchase supplies or postage).
- Customer Deposit Payments/Refunds (Payment taken towards a purchase such as a layaway).
Although this article, Journal Entries Created in Springobard Retail for Quickbooks Online Integration, shows the journal entries that are created in the Springboard Retail to QBO Integration, you may find this to be helpful in derviving your list of required journal entries.
(2) Creating and Saving the Reports you Need
Next you will need to create and save the necessary reports in Springboard Retail to obtain the dollar amounts (debits and/or credits) in your required journal entries. Below are some helpful articles related to creating, saving and running those reports:
(3) Use the Reports To Create Your Journal Entries
Next you will use the reports you have created to provide the debit and/or credit amounts in your journal entries. For example, let's say you and your accountant have decided to book a weekly journal entry for POS tickets. You may use a journal entry similar to this:
Dr. Payment Type
Dr. Cost of Goods Sold
Dr. Sales - Markdowns
Dr. Sales - Returns
Cr. Gross Sales
Cr. Inventory On Hand
Cr. Sales Tax Payable
Using the first report (Monthly Sales (Sales to Payment Reconciliation) in this article Examples of Helpful Accounting and Bookkeeping Reports You Can Easily Create, you can populate your amounts as follows:
Dr. Payment Type: Payments >> Net Payments
Dr. Cost of Goods Sold: Location Sales >> Net Item Sold Cost
Dr. Sales - Markdowns: Source Sales >> Net Markdowns
Dr. Sales - Returns: Source Sales >> Gross Returns
Cr. Gross Sales: Source Sales >> Gross Sales
Cr. Inventory On Hand: Location Sales >> Net Item Sold Cost
Cr. Sales Tax Payable: Sales Tax >> Net Amount Collected
Remember to filter on the dates you want to book the journal entry for (for example yesterday, last week, or last month if you want to book a journal entry in total for the previous month).
Remember you can group by (1) location to get a break down of the journal entry (sales) by location, (2) by day (if you want to book a journral entry for each day), or (3) even by any custom field if you treat, as an example, footwear and apparel sales differently in your financials.
(4) Use our Help Center to Answer all your Accounting Related Questions
Springboard Retail Sales Reporting Metrics Explained
Springboard Retail Inventory Reporting Metrics Explained
What is the Difference Between Gross and Net Sales?
What is the Difference Between Net Sales and Net Payments?
How to Report on Your Sales Tax Collected in Springboard Retail
Location Sales Vs Source Sales
You can search our Help Center 24/7 to get the answers you need! If you can't find an answer to your question, please feel free to use the chat icon in the Help Center to receive support from a member of the Springboard Retail Customer Success Team!