VAPO/ALT - Accounting User Manual

0 %

Course content

Accounting Dashboard
- View, Edit & Save Personalized Dashboard
General Accounting Set up
- Basic Accounting Setup
- How to Create a Payment Term ( Simple and Advance & Reporting)
- How to update payment terms for a customer/Supplier
- How to activate new currencies and check Live rates
- How to Create Fiscal Positions ( OS Partner / Wholesale, Online, InterCompany Customers)
- How to Merge a new account to an existing account
- How the Find & recode feature works in Odoo
- How to update the email ID of the company
Analytic Accounts
- How to Create Fiscal Positions (Wholesale)
- How to Create Fiscal Positions (OS Partner)
- How to Create Fiscal Positions (Inter Company)
- How to Create an Analytic Plan and Analytic Account (Stores/ Territory)
- How to Update Shopify Analytic Accounts
- How to run reports based on Analytic Accounts ( Territory/Stores)
- How the analytic automation works based on territory
Chart of Accounts
- How to add a GL Account /Edit /Deprecate/Duplicate & Delete
- How to create an Account Group & Assign a GL account to the group
Day to Day Transactions
- How to Create, Reverse, Cancel & Delete a Journal Entry
- How to edit a paid vendor bill
- How to cancel or delete a bill
Sales
- How to Create a Customer Deposit
- Receive Customer Deposit and Reconcile against Bank
- Create a balance customer invoice and reconcile the payment to the invoice
- How to Manually Register a Payment
- How to Create a Batch Deposit
- How to Bulk Invoice Sales Orders
- How to create a Credit note with a Return
- How to create a Credit Note without a return
- How to Cancel or Delete Invoices
- How to Create an Invoice and Check the Journal
- How to create and manage customer over payment
- How to cancel or delete a payment
- How to apply current credit to an older invoice - where the period is already locked
- How to view report for Sales By Customer (Invoice date), Customers spending report (Invoice date)
- How to account for minor adjustments
- How the credit note/payment can be partially allocated for multiple invoices
Banks & Bank Reconciliations
- How to Create a Bank Journal/Account
- How to Create an Internal Bank Transfer & Reconcile to a Bank Feed
- How to Create a Reconciliation Model (Bank Rules)
- How to Create and Import Bank Statements (manually)
- How to Edit/ Delete a Bank Statement lines
- How to un reconcile a Bank Feed
- How to delete Bank Statement
- How to Reconcile Bank Statements
- Bank Transfer From Foreign to Local
- Reconcile a Bill against the bank (pay a bill through reconciliation)
- Reconcile an Invoice against the bank (pay an invoice through reconciliation)
- Reconcile a manually registered supplier payment
- Reconcile a manually registered customer payment
- Reconcile a customer overpayment
- How to reconcile a batch deposit
- How to reconcile using reconciliation models
- Local Inter Bank Transfers
- Reconcile a direct transaction ( Spend/Receive money)
- Inter bank fund transfer through manual operation
- Reconcile a batch payment
- Foreign Inter bank transfers - (Between Foreign and Local)
- Foreign Inter bank transfers - Foreign to Foreign
- How to attach a document at manual reconciliation
Fixed Assets
- How to create a fixed asset GL account
- How to create an Asset Model
- How to Add a Fixed Asset through the Bill & Confirm the Draft Asset Created
- How to Compute Depreciation
- How to Run a Depreciation Schedule
- How to Dispose an Asset
- How to Sell an Asset
- How to Re-evaluate an asset
- How to Pause the Depreciation
- Different depreciation methods & Calculation Methods
- How to import fixed assets in bulk to Odoo
- How to Roll back depreciation and edit depreciation
Year/Month End
- How to close the Fiscal Year
- How to Lock Dates
- How to create stock adjustment
- How to use Accounting Reconciliation Feature
- Opening up closed financial period to allocate/reconcile a payment or credit note
Reports
- How to view reports - AR/AP & Partner Ledger
- How to view reports - P&L, BS and CF
- How to view Executive Summary
- How to View Other Accounting Reports
- How to view the sales & cogs report (customized report)
Purchase Order approval
- How to setup the approval route & create PO Teams
- How to setup the minimum & maximum amount & lock the totals
- How to add custom conditions
- How to apply the PO approval team and add followers for approval notifications
- How to create a PO after setting up the application (user level)
- Approver Reject the RFQ
- How to create a bill and send for approval?
- How to approve a bill?
- Basic Setup & Creating Bill approval teams
- How to Approve a PO. ( Notifications & Approval)
- How to Approve a Bill (Notifications and Approvals)
POS
- How to Update POS analytic accounts for each store
- How to Update POS Sales & COGS Accounts for each store
- Explanation of POS journals
- How to reconcile Bank deposit (Bank Payments)
- How the cash count variances will be recorded in the GL (Closing Register) - To be added once customization is done
- How to reconcile Cash Outs for the Safe- To be completed once customization is done
POS Reconciliations
- How to Reconcile POS orders Vs POS payments
- How to Reconcile cash orders against cash book deposits to make sure all the cash deposits have been recorded in your cash account
- How to reconcile Cash Safe Clearing Account (Incomplete and unfinalized topic)
Purchasing
- How to Reconcile a Vendor Deposit directly through Bank Rec ( No Supplier Remittance / Not a Foreign Currency Payment )
- How to Create a Vendor Deposits -Through stand alone payment if you want to send a payment remittance report
- How 3-way reconciliation works in Odoo
- How 2-way reconciliation works in Odoo
- How to Create a Bill through document app and link to an existing PO
- How to apply the supplier Deposit to the Final Bill
- How to Reconcile the final Payment directly through bank
- How to Create a Vendor Deposit for a Foreign PO
- How to Create a Foreign Bill through PO (Update Manual Exchange Rate if needed)
- How to apply the Vendor Deposit
- How to Manually Register a Payment and reconcile through bank
- How to Create a Freight bill with GST on Imports - AU/NZ
- How to apply landed cost
- Understanding Landed Cost Journal and Cost distribution
- How to Pay a Bill through Trade Loan
- How to reconcile the trade loan settlement
- How to create a deposit for multiple Bills - Foreign Vendor ( Eg : Use one deposit to settle 30% of multiple bills)
- How to create a deposit for multiple Bills - Foreign Vendor ( Eg : Use one deposit to settle multiple bills related to same PO ( No restrictions in application %)
- How to Create the Final Bill through PO
- How to Create a Supplier Credit Note
- How the credit note for landed cost works
- DLO batch payment - how to remove and redo a batch payment
- How to send supplier payment remittance batch and individual
- How to view a Payments history Report for customers to update the Credit tier list
Non stock purchasing
- How to upload a bill in accounting module
- How to Upload the bill document directly to the accounting module ( Edit or Update Bill details manually/ send for digitalization)
- How to Forward Bills to Documents App or Manually Upload Bills to Document app
- How to Update & Organize the document uploaded (Split Multiple Bills Document)
- How to Create bills in Document App (Single & Bulk)
- How to send for digitalization and to confirm & approve bills
- How to duplicate a previous bill and update a new bill
- How to purchase digitalisation credits
- How to manually create a bill and attach the bill received.
Expense Module
- How to Create an Expense Product
- How to record Expenses - Incurred by Employee
- How to record Expenses - Incurred by Company
- How to manually Attach a receipt
- How to Create the Expense Reports and Submit - Incurred By Employee/ Company
- Approve an Expense Report, post entries, Pay & reconcile the payment- Incurred By Employee
- Approve an Expense Report, post entries, Pay & reconcile the payment- Incurred By Company
- How to use the Expense Analysis Report
- How to use the Mobile APP
- Mobile App installation instructions
- How to split the expense
- How to change the manager to approve the expense report
- Credit card reconciliation with expense claim
Shopify Sales
- How to map Shopify Revenue & COGS Accounts
- How to Update Shopify Analytic Accounts
- How the Order/Invoice and Payment created in Odoo
- How to do a Shopify Vs Odoo Order Reconciliation
- How to do a Odoo Sales Order Vs Invoice Reconciliation
- How to do a Payment gateway reconciliation between clearing account and payment settlement report
- How to perform a Payment Clearing Account Reconciliation
- How to setup a new Payment gateway in Odoo
- How to run the Shopify Report with Staff Benefit Tags
- How to Tag Orders with Staff benefits
Invoice Reminders
- How to Setup Follow up Levels
- How to select customers to send automatic reminders
- How to update the minimum amount for reminders
- How to bulk send Invoice Reminders
- How to update the reminder Email Template
- How the automatic reminders will work
Customer Statements
- How to Manually send customer statements - Individually
- How to Manually send customer statements - Bulk
- How to update Settings for Customer Statements
- How to update email ID of the company
- How to check the credit tiers of the contacts
- How to account for bad debts and write it off
Tax
- How to Create a New Tax Code and update Grids if necessary
- How to Configure your tax receivable and payable account
- How to Run the Tax Report - NZ
- How to Run the Tax Report- AU
- How to view the Late GST Claim Report
- How to Lodge the Tax Return
- How to Close the Tax Entry
Supplier Batch Payment
- How to Update Supplier Bank Account - AU
- How to Update Supplier Bank Account - NZD
- How to process a DLO batch payment
Product Categories
- How to Create a product category
- How to assign a product to a product category
- How to check SO & Item Delivery Journal
- Product category account mapping explanation
Inventory Valuation Journals
- How to check PO & Item Receipt Journals
- How to check Supplier Bill Journal Explanation
- How to check Customer Invoice journals & COGS
- PO & Bill variance Management Explanation in Odoo
Analytic Accounts
- How to Create an Analytic Plan and Analytic Account
- How to Create / Update Analytic Distribution Models ( Distributors /Manufacturers/Vape Stores/Companies /Online / Head Office )
- How to Update the Customer Tag in Contact Card
- How to run reports based on Analytic Accounts
- How to Create/Edit Analytic Account of each territory
Rebates
- How to Update Contact details & Bank details for Service Stations
- How to update the contact Tag for the service station vendor
- How to archive old dealer details
- How to bulk import Rebate Bills
- How to create DLO payments in Bulk for Rebates

How to map Shopify Revenue & COGS Accounts

Shopify Revenue & COGS Accounts mapping with Odoo refers to the process of linking Shopify’s Revenue and Cost of Goods Sold (COGS) accounts with Odoo’s accounting system. This allows you to track your Shopify sales and expenses directly within Odoo.

As we are in need of having separate Sales & COGS account, Shopify sites/ instances should be mapped to the relevant COGS & REVENUE account.

01. Navigate in to shopify module in the dash board

02. Under the configuration click on Instances

03. Here you can see all the relevant instances/sites you have connected to the odoo.

04. Once you click over the site name you will be able to see the configurations to the particular site, and under the Account section you have to set up the relevant income and expense account

Income account -NZ Online Sales Account
Expense account - COGS NZ Online Sales Account

Rating

0 0

Views
73	Total Views
1	Members Views
72	Public Views

Add Quiz

VAPO/ALT - Accounting User Manual

Completed

How to map Shopify Revenue & COGS Accounts