1/19/2024 0 Comments Lightspeed onsite user accounts![]() The retailer's revenue increases by $100, their inventory level decreases by $50, which is offset by an increase in the cost of their goods sold by the same amount. Assuming a cost average of the product of $50, the GL accounts are affected like this: For example, an invoice taxed at 10% selling an item for a $100 sell price totals $110. The Invoice export (also called Sales) contains data about an invoice in OnSite. If you sell an item for $10 to a customer without them paying for it, your AR is $10 until they pay, when it returns to $0. If you purchase an item for $10 from a supplier, your AP is $10. AP represents the overall amount a retailer owes (or is owed by) their suppliers. AR represents the overall amount that a retailer is owed (or owes) their customers. ![]() There are two additional numbers that are affected by these exports: accounts receivable and accounts payable. For a glossary of accounting terms go to About accounting. The type is used in QuickBooks for Mac, and should accurately reflect the kind of account being used in OnSite. The type assigned to each account is not used in OnSite though it is displayed in the GL Accounts setup window. The table shows which GL accounts are affected by each of these files, and their type. There are up to five regularly-exported files sent from OnSite to QuickBooks: invoices, payments, inventory adjustments, supplier invoices and transfers (for Multi-Stores). As you become accustomed to the process and understand which amounts correspond between the two software packages, you can choose to export on a weekly basis, and, depending on the level of detail you want in QuickBooks, choose to do Summarized exports. This makes any discrepancies easier to spot, and reconciliation can be done quickly. ![]() We recommend that you export data from Lightspeed to QuickBooks daily, and with Detailed exports. You should do the initial setup of the GL accounts (your Chart of Accounts) with the aid of a Chartered Accountant before you do any accounting integration with OnSite. This topic outlines each export file, the GL accounts that are affected, and how they relate to other GL accounts. To do this, it's important to know how these numbers and accounts relate to each other. ![]() After you export your information from OnSite and import it to QuickBooks, confirm that the accounts are balanced. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |