Question has been asked on the community mailing list here:
https://www.odoo.com/groups/community-59/community-31930496

Feel free to add your feedbacks on the subject here.

Documentation

OnPay (https://onpay.com) built the best online payroll service by combining 30 years of experience as a payroll provider with the latest technology.

This module aims to connect Odoo with OnPay to run payroll. As of today, OnPay API does not support sending input data for payroll run. So we decided to generate a csv file for you to export timesheets and expenses out of Odoo and import it (without opening it) into OnPay.

Configuration

• Go to Employees
• Set the OnPay ID on your employees
• Go to Timesheets > Configuration > Time Types
• Match each of your time type with an OnPay pay type

Usage

On Odoo

• Go to Employees
• Switch to the list view
• Select a list of employees
• In the Action menu, select "Export to OnPay"
• In the popup window, select the pay period. It defaults to the previous half-month period.
• Click on Export

On OnPay

• Go to https://app.onpay.com/app/login
• Go to Your Company > Payroll > Upload Hours
• Select the file downloaded from Odoo
• Click on "View uploaded files"
• Click "Process" for the file we just imported

Roadmap

• Allow to configure the pay period

Technical Specifications

onpay.pay.type

• Add a char field "Name" (name)
• Add a char field "Code" (code)
• Add a boolean "Treat as cash" (treat_as_cash)
• Load the data provided in the sheet "Input - Pay Types" of the mapping

task.time.type

• Add a many2one field "OnPay Pay Type" (onpay_pay_type_id ) to onpay.pay.type

onpay.export

• Create the wizard
• Add a date field "From" (date_from)
• Add a date field "To" (date_to)
• Add a button "Export" to call export_onpay() on hr.employee

ir.action.server

• Add a server action "Export to OnPay" on hr.employee list view to call the wizard onpay.export

hr.employee

• Add a char field "OnPay ID" (onpay_id)
• Add a method export_onpay() to:
  • Get the timesheet entries for the selected employees and payroll period entered in the wizard
  • Get the employee approved expenses for the selected employees and payroll period entered in the wizard
  • Group them by data source (timesheets or expenses) and pay type
  • Generate the files using the mapping
  • Provide the generated file to the user

• Add a new object "1099.type" with a char field "Name"
• Add a many2one field "1099 Type" on res.partner to 1099.type
• Create a SQL view from account.payment with:

• Vendor
• 1099 Type
• Payment
• Date
• Amount

• Add a pivot view with:

• Vendor
• 1099 Type
• Payment
• Date
• Amount

• Add a menu item "1099 Report" under Accounting / Reporting
• Add data for 1099.type with: 1099-A, 1099-B, 1099-C, 1099-CAP, 1099-DIV, 1099-G, 1099-H, 1099-INT, 1099-K, 1099-LTC, 1099-MISC, 1099-OID, 1099-PATR, 1099-Q, 1099-R, 1099-S, 1099-SA, RRB-1099 and SSA-1099

After installing l10n_us_gaap it is not possible to install point_of_sale module since it is expecting default_pos_receivable_account_id on chart template.

I saw you are working on v10, but is 9 available for production?

US Accounting Profile

This module provides all the dependencies, data, parameters and configuration panel to have Odoo as an accounting software ready for US accountants and equivalent to local solutions like Quickbooks.

0.0.1

#7

• account_due_list

0.0.2

• account_reversal: OCA/account-financial-tools#445
• account_payment_batch_process: OCA/account-payment#138
• account_payment_credit_card: OCA/account-payment#139
• partner_aging: OCA/account-payment#136 by @Sudarshan1607
• partner_daytopay: OCA/account-invoice-reporting#53 by @bodedra
• account_check_printing_report_base: OCA/account-payment#147 by @smangukiya
• l10n_us_check_writing_address: #8 by @Sudarshan1607
• l10n_us_form_1099: #13 by @wujenne2
• l10n_us_account_profile: #11 by @Sudarshan1607

0.0.3

• account_banking_reconciliation: OCA/account-reconcile#174 by @bodedra
• partner_financial_risk: OCA/partner-contact#360
• partner_sale_risk: OCA/partner-contact#309
• partner_stock_risk: OCA/partner-contact#309
• l10n_us_account_profile:

Reproduced on Runbot: http://3373920-10-0-c0adc3.runbot2.odoo-community.org/web?debug=1#min=1&limit=80&view_type=list&model=account.payment&action=123

Print Payment Check Top

Print Payment Check Middle or Bottom

Depends: fieldservice, crm, contacts
License: AGPL

This module allows you to synchronize your Odoo database with ALN Data (https://www.alndata.com) once a month.

Usage

• Go to Settings
• Activate the developer mode
• Go to Settings > Technical > Parameters > System Parameters
• Search and edit "alndata.api.key"
• Enter your API key in the value
• Go to Settings > Technical > Automation > Scheduled Actions
• Search and open "Sync with ALN Data"
• Change the frequency if you want the sync to happen more than once a month

Technical Specifications

res.partner.industry

• Add a unique required char field "Reference" (ref)
• Add a many2one field "Parent" (parent_id) to res.partner.industry
• Compute the display_name with the name of the parents: "Market / Submarket"

ir.config_parameter

• Add a key alndata.api.url: http://api2.alndata.com/odata/

• Add empty keys:

• alndata.api.key
• alndata.markets.rowversion
• alndata.submarkets.rowversion
• alndata.managementcompanies.rowversion
• alndata.owners.rowversion
• alndata.apartments.rowversion
• alndata.contacts.rowversion
• alndata.newconstructions.rowversion

crm.lead

• Add a method cron_sync_with_aln(self)

• for each data set in Markets, Submarkets, Job Categories, Management Companies, Owners, Apartments, Contacts, New Constructions
  • get the related RowVersion in the ir.config_parameter
  • request all updated records (using the RowVersion) or all records if None ordered by RowVersion
  • Search the record based on the key fields
  • Create or update the returned record based on the result using the mapping
  • if the crm.lead has been converted into a res.partner, update the res.partner as well
  • Update the ir.config_parameter with the new RowVersion

ir.cron

• Add a scheduled action "Sync with ALN Data" on crm.lead to execute cron_sync_with_aln once a month.

How do I generate the ACH file from the payment to the vendor? Check is the only option.

Version 13

• Avalara (http://www.avalara.com)
• SmartCalcs (https://www.taxjar.com/smartcalcs/):
• Tax Cloud (http://www.taxcloud.com): https://www.odoo.com/apps/modules/13.0/account_taxcloud/
• Zip-Tax (http://zip-tax.com):

Version 12

• Avalara (http://www.avalara.com) - https://github.com/sodexis/avatax_connector
• SmartCalcs: https://www.taxjar.com/smartcalcs/ - By @hveficent - #47
• Tax Cloud (http://www.taxcloud.com): https://www.odoo.com/apps/modules/12.0/account_taxcloud/
• Zip-Tax: http://zip-tax.com/

Version 11

• Avalara (http://www.avalara.com)
• SmartCalcs: https://www.taxjar.com/smartcalcs/
• Tax Cloud (http://www.taxcloud.com): https://www.odoo.com/apps/modules/11.0/account_taxcloud/
• Zip-Tax: http://zip-tax.com/

Version 10

• Avalara (http://www.avalara.com) - By @obulkin - OCA/sale-workflow#435
• SmartCalcs: https://www.taxjar.com/smartcalcs/
• Tax Cloud (http://www.taxcloud.com): https://www.odoo.com/apps/modules/10.0/account_taxcloud/
• Zip-Tax: http://zip-tax.com/

Version 9

• Avalara (http://www.avalara.com):

• https://www.odoo.com/apps/modules/9.0/avatax_connector/
• https://www.avalara.com/integrations/odoo9/

Version 8

• Avalara (http://www.avalara.com): https://www.avalara.com/integrations/odoo8/

If you are interested, please comment below or contact me at [email protected].

Background

The 1099 app currently reports 1099 by vendor.

Requirements

However, it does not allow you to include/exclude particular vendor payments. Company may have vendors where some of their payments need to be reported on 1099s where others should be excluded.

The 1099 app needs to be modified to:

• Mark payments made to 1099 vendors with 1099 classifications.
• Identify vendor bills transaction lines as 1099 eligible and which lines are excluded.
• Modify 1099's report to show 1099 classifications by vendor by transaction
• Include tax id on 1099 report by vendor by transaction.
• 1099 report should be able to be filtered by paid date of invoices.
• Vendor bills will be split on the 1099 report if multiple lines have different 1099 types.

Company would like the ability to classify transactions as 1099 at the transaction level as there are vendors that could bill them for services as well as inventory on the same vendor bill. 1099 transactions will show on the 1099 report after the invoice has been fully paid. If a vendor bill is partially paid, it will not be included on the 1099 report until it is fully paid.

Technical Specifications

account.move.line

• Add the following fields:

is_1099 = fields.Boolean("Is a 1099?")
type_1099_id = fields.Many2one("type.1099", string="1099 Type")
box_1099_misc_id = fields.Many2one("box.1099.misc", string="1099-MISC Box") 

• They must default to the value of the selected vendor.
• Add a related field “Tax ID” to the "Legal ID" field of the selected vendor. Make sure it is available on the report (pivot view).

1099 Report

• Update the report to use those new fields and not the ones from the vendor.
• Provide the migration script to set the new fields based on the vendor info so the report gives the same values before and after the upgrade of the module.

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-12.0

Modules to migrate

• l10n_us_form_1099 - By @nikul-serpentcs - #28
• l10n_us_account_profile - By @murtuzasaleh
• l10n_us_gaap - By @dduarte-odoogap - #37
• l10n_us_gaap_mis_report

Improvements

• Remove the dependency on l10n_us_check_writing
• Add the dependency on account_check_printing_report_base in https://github.com/OCA/account-payment
• Relicense the module to AGPL-3

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-11.0

Dependencies

OCA/account-financial-tools#551

• account_reversal

OCA/account-payment#161

• account_check_printing_report_base
• account_payment_batch_process
• account_payment_credit_card
• partner_aging

OCA/account-invoice-reporting#63

• partner_time_to_pay

OCA/account-reconcile#186

• account_banking_reconciliation

Modules to migrate

• l10n_us_form_1099 by @max3903 in #21
• l10n_us_uom_profile
• l10n_us_check_writing_address by @Sudarshan1607 in #25 and @murtuzasaleh in #31
• l10n_us_account_profile by @Sudarshan1607 in #26 and @murtuzasaleh in #32

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-16.0

Modules to migrate

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

• l10n_us_form_1099 - By @lk-eska - #92
• l10n_us_gaap - By @lk-eska - #91

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-14.0

Modules to migrate

• l10n_us_form_1099 by @JevinD in #63
• l10n_us_gaap
• l10n_us_gaap_mis_report

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

https://en.wikipedia.org/wiki/Form_1099

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-15.0

Modules to migrate

• account_banking_ach_base - By @thinkwelltwd - #107
• account_banking_ach_credit_transfer - By @thinkwelltwd - #109
• account_banking_ach_direct_debit - By @thinkwelltwd - #108
• l10n_us_form_1099 - By @thinkwelltwd - #113
• l10n_us_partner_legal_number - By @thinkwelltwd - #106

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

Hello,
I would like to use the module l10n_us_check_writing_address however when installed on my server (and also when testing on the run-bot) I receive the following warning.

I have tried selecting top middle and bottom in my company settings, all of them raise the warning, however i can use the base module and the dlt103 check module to produce a pdf of the check. Am i missing a setup step? any help will be greatly appreciated.

The screenshot is from the oca runbot accessed from the module page in question.

Thank you in advance

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-10.0

Modules to migrate

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-9.0

Modules to migrate

Todo

https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-13.0

Modules to migrate

• account_banking_ach_base
• account_banking_ach_credit_transfer
• account_banking_ach_direct_debit
• l10n_us_account_profile
• l10n_us_form_1099 - By @murtuzasaleh in #51
• l10n_us_gaap - By @JoanSForgeFlow in #53

Missing module? Check https://github.com/OCA/maintainer-tools/wiki/%5BFAQ%5D-Missing-modules-in-migration-issue-list

I got error when I tried to install United States Sample GAAP Chart of Accounts for odoo v13 on localhost using windows 10

Module
United States Sample GAAP Chart of Accounts

Describe the bug
File Attached

GAAP Issue.txt