Hi, So we've just figured out how to setup the transactions to reflect our salaried positions here. We don't do our own calculations for the actual deductions, we use a service from "Service de paie Desjardins" (http://desjardins.com/) that does all this, including money transfers for a fee.
They give us various reports after doing the actual work, the thing is: they are very cryptic and hard to deal with. There is a "General ledger report" thing that's supposed to list transactions you add to your general ledger to reflect the deductions/payments associated with the money they take out of your account, but it doesn't really work out. I was hoping I would be able to just automatically parse this file every two week, but it lacks some information, so I'll try to work a bit more with the Desjardins tech support to try to figure this out. Nevertheless, I figured most of it out, and I was able to setup a single transaction to reflect the deductions and payments. I had to create a few extra account to reflect this. I attached a copy of our SQL COA. I mainly added accounts in 54XX and 24XX where XX is a similar ID for the deduction in expenses and liabilities. 2410 2624 Salaires à payer 2420 2627 Assurance-emploi à payer 2430 2627 RRQ à payer 2440 2627 CSST à payer 2450 2627 FSS à payer 2460 2627 RQAP à payer 2470 2624 Indemnités de vacances à payer 2480 2628 Impôt sur le revenu à payer 5420 8622 Dépenses d'assurance-emploi 5430 8622 Dépenses RRQ 5440 8622 Dépenses CSST 5450 8622 Dépenses FSS 5460 8622 Dépenses RQAP 5470 8622 Dépenses Vacances (Sorry if those are in french, I can translate if required. This is also quite Quebec-specific so it will be of limited use for people outside. :) I can provide sample transactions for people interested. A.
INSERT INTO chart VALUES (10001, '1060', 'Compte ch�que', 'A', 'A', 'AR_paid:AP_paid', '1002', false); INSERT INTO chart VALUES (10002, '1065', 'Petite caisse', 'A', 'A', 'AR_paid:AP_paid', '1001', false); INSERT INTO chart VALUES (10089, '5417', 'Recherche de contrat et subventions', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10004, '1200', 'Comptes clients', 'A', 'A', 'AR', '1060', false); INSERT INTO chart VALUES (10042, '2430', 'RRQ � payer', 'A', 'L', '', '2627', false); INSERT INTO chart VALUES (10023, '2420', 'Assurance-emploi � payer', 'A', 'L', '', '2627', false); INSERT INTO chart VALUES (10007, '1800', 'AUTRES IMMOBILISATIONS', 'H', 'A', '', '1900', false); INSERT INTO chart VALUES (10008, '1820', 'Meubles et accessoires', 'A', 'A', '', '1787', false); INSERT INTO chart VALUES (10009, '1825', 'Amortissement cumul� des meubles et des accessoires', 'A', 'A', '', '1788', true); INSERT INTO chart VALUES (10010, '1840', 'V�hicules automobiles', 'A', 'A', '', '1742', false); INSERT INTO chart VALUES (10011, '1845', 'Amortissement cumul� des v�hicules automobiles', 'A', 'A', '', '1743', true); INSERT INTO chart VALUES (10012, '2100', 'Comptes fournisseurs', 'A', 'L', 'AP', '2621', false); INSERT INTO chart VALUES (10013, '1000', 'ACTIF COURANT', 'H', 'A', '', '1000', false); INSERT INTO chart VALUES (10014, '2000', 'PASSIF COURANT', 'H', 'L', '', '2620', false); INSERT INTO chart VALUES (10015, '2160', 'Taxes f�d�rales � payer', 'A', 'L', '', '2683', false); INSERT INTO chart VALUES (10016, '2170', 'Taxes provinciales � payer', 'A', 'L', '', '2684', false); INSERT INTO chart VALUES (10017, '2310', 'TPS', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2685', false); INSERT INTO chart VALUES (10018, '2320', 'TVQ', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2686', false); INSERT INTO chart VALUES (10021, '2400', 'RETENUES SUR SALAIRE', 'H', 'L', '', '2620', false); INSERT INTO chart VALUES (10024, '2480', 'Imp�t sur le revenu � payer', 'A', 'L', '', '2628', false); INSERT INTO chart VALUES (10025, '2600', 'PASSIF � LONG TERME', 'H', 'L', '', '3140', false); INSERT INTO chart VALUES (10026, '2620', 'Emprunts bancaires', 'A', 'L', '', '2701', false); INSERT INTO chart VALUES (10027, '3300', 'CAPITAL SOCIAL', 'H', 'Q', '', '3500', false); INSERT INTO chart VALUES (10028, '3350', 'Actions ordinaires', 'A', 'Q', '', '3500', false); INSERT INTO chart VALUES (10029, '4000', 'REVENUS DE VENTE', 'H', 'I', '', '8000', false); INSERT INTO chart VALUES (10040, '5410', 'Salaires', 'A', 'E', 'AP_amount', '9060', false); INSERT INTO chart VALUES (10063, '5800', 'Taxes d''affaires, droits d''adh�sion et permis', 'A', 'E', 'AP_amount:IC_expense', '8760', false); INSERT INTO chart VALUES (10032, '4400', 'AUTRES REVENUS', 'H', 'I', '', '8090', false); INSERT INTO chart VALUES (10033, '4430', 'Transport et manutention', 'A', 'I', 'IC_income', '8457', false); INSERT INTO chart VALUES (10034, '4450', 'Gain sur change', 'A', 'I', '', '8231', false); INSERT INTO chart VALUES (10035, '5000', 'CO�T DES PRODUITS VENDUS', 'H', 'E', '', '8515', false); INSERT INTO chart VALUES (10036, '5010', 'Achats', 'A', 'E', 'AP_amount:IC_cogs:IC_expense', '8320', false); INSERT INTO chart VALUES (10046, '5615', 'Publicit� et promotion', 'A', 'E', 'AP_amount:IC_expense', '8520', false); INSERT INTO chart VALUES (10038, '5100', 'Frais de transport', 'A', 'E', 'AP_amount:IC_expense', '8457', false); INSERT INTO chart VALUES (10039, '5400', 'FRAIS DE PERSONNEL', 'H', 'E', '', '', false); INSERT INTO chart VALUES (10041, '5420', 'D�penses d''assurance-emploi', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (10043, '5430', 'D�penses RRQ', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (10044, '5440', 'D�penses CSST', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (10045, '5600', 'D�PENSES ADMINISTRATIVES ET G�N�RALES', 'H', 'E', '', '', false); INSERT INTO chart VALUES (10052, '5700', 'Fournitures de bureau', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '8811', false); INSERT INTO chart VALUES (10047, '5620', 'Cr�ances irr�vocables', 'A', 'E', 'AR_paid:AP_paid', '8590', false); INSERT INTO chart VALUES (10048, '5660', 'Amortissement de l''exercice', 'A', 'E', '', '8670', false); INSERT INTO chart VALUES (10050, '5685', 'Assurances', 'A', 'E', 'AP_amount', '9804', false); INSERT INTO chart VALUES (10051, '5690', 'Int�r�ts et frais bancaires', 'A', 'E', '', '9805', false); INSERT INTO chart VALUES (10054, '5780', 'T�l�phone', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '9225', false); INSERT INTO chart VALUES (11232, '5450', 'D�penses FSS', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (11236, '5670', 'Imp�t sur le revenu (f�d�ral)', 'A', 'E', '', '9990', false); INSERT INTO chart VALUES (10055, '5785', 'Voyages et loisirs', 'A', 'E', '', '8523', false); INSERT INTO chart VALUES (10056, '5790', 'Services publics', 'A', 'E', 'AP_amount', '8812', false); INSERT INTO chart VALUES (10057, '5810', 'Perte sur change', 'A', 'E', '', '8231', false); INSERT INTO chart VALUES (10058, '1205', 'Provisions pour cr�ances douteuses', 'A', 'A', '', '1063', false); INSERT INTO chart VALUES (10059, '2680', 'Emprunt aupr�s des actionnaires', 'A', 'L', 'AP_paid', '2780', false); INSERT INTO chart VALUES (10060, '5610', 'Frais comptables et juridiques', 'A', 'E', 'AP_amount', '8862', false); INSERT INTO chart VALUES (10061, '4440', 'Int�r�ts', 'A', 'I', 'IC_income', '8090', false); INSERT INTO chart VALUES (10062, '5765', 'R�paration et entretien', 'A', 'E', 'AP_amount', '8964', false); INSERT INTO chart VALUES (10065, '2200', 'Carte VISA/Desjardins 4015', 'A', 'L', 'AP_paid', '2362', false); INSERT INTO chart VALUES (10049, '5680', 'Imp�t sur le revenu (provincial)', 'A', 'E', '', '9990', false); INSERT INTO chart VALUES (10067, '4420', 'Frais de contingence', 'A', 'I', 'IC_income', '8000', false); INSERT INTO chart VALUES (10066, '4410', 'Cotisations', 'A', 'I', 'IC_income', '8221', false); INSERT INTO chart VALUES (10069, '4020', 'Hebergement', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10003, '1500', 'INVENTAIRE', 'H', 'A', '', '1120', false); INSERT INTO chart VALUES (10022, '1520', 'Inventaire / G�n�ral', 'A', 'A', 'IC', '1122', false); INSERT INTO chart VALUES (10005, '1530', 'Inventaire / Pi�ces de rechange', 'A', 'A', 'IC', '1122', false); INSERT INTO chart VALUES (10019, '2470', 'Indemnit�s de vacances � payer', 'A', 'L', '', '2624', false); INSERT INTO chart VALUES (10006, '1540', 'Inventaire / Mati�res premi�res', 'A', 'A', 'IC', '1122', false); INSERT INTO chart VALUES (10074, '5500', 'Pigistes', 'H', 'E', '', '9110', false); INSERT INTO chart VALUES (10121, '2330', 'TVH', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2685', false); INSERT INTO chart VALUES (10068, '4010', 'Webdev', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10090, '4030', 'Graphisme', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10071, '4040', 'Sysadmin', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10070, '4050', 'Support technique', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10072, '4060', 'Formation', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10081, '5710', 'Courrier & frais postaux', 'A', 'E', '', '9808', false); INSERT INTO chart VALUES (10082, '5050', 'Pi�ces de rechange', 'A', 'E', 'AP_amount:IC_cogs', '8320', false); INSERT INTO chart VALUES (10083, '5020', 'Materiel informatique', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '9150', false); INSERT INTO chart VALUES (10084, '5030', 'Frais de colocation', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '8910', false); INSERT INTO chart VALUES (10085, '5040', 'Noms de domaine', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '', false); INSERT INTO chart VALUES (10073, '4070', 'Noms de domaine', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (10030, '4080', 'Ventes g�n�rales', 'A', 'I', 'AR_amount:IC_income:IC_sale', '8000', false); INSERT INTO chart VALUES (11234, '5460', 'D�penses RQAP', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (11238, '5470', 'D�penses Vacances', 'A', 'E', '', '8622', false); INSERT INTO chart VALUES (10078, '5550', 'Negotiation contrats', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (10079, '5560', 'Kickbacks', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (11356, '2410', 'Salaires � payer', 'A', 'L', '', '2624', false); INSERT INTO chart VALUES (11352, '2450', 'FSS � payer', 'A', 'L', '', '2627', false); INSERT INTO chart VALUES (10076, '5510', 'Webdev (pigistes)', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (10075, '5520', 'Graphisme (pigistes)', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (10092, '5530', 'Sysadmin (pigistes)', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (10077, '5540', 'Formation (pigistes)', 'A', 'E', 'AP_amount:IC_expense', '9110', false); INSERT INTO chart VALUES (10020, '2440', 'CSST � payer', 'A', 'L', '', '2627', false); INSERT INTO chart VALUES (11068, '5418', 'R�le de communication marketing', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10053, '5760', 'Loyer', 'A', 'E', 'AP_amount:IC_expense:IC_cogs', '9811', false); INSERT INTO chart VALUES (11354, '2460', 'RQAP � payer', 'A', 'L', '', '2627', false); INSERT INTO chart VALUES (11064, '5411', 'R�le de vente', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10086, '5412', 'R�le de coordination', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10088, '5414', 'R�le administration syst�me', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10689, '5413', 'R�le de d�veloppement web', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10712, '5415', 'R�le de secr�tariat', 'A', 'E', 'AP_amount:IC_expense', '9060', false); INSERT INTO chart VALUES (10087, '5416', 'R�le de comptabilit�', 'A', 'E', 'AP_amount:IC_expense', '9060', false);
signature.asc
Description: Digital signature
------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/
_______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
