Sage 50 Accounting Payroll

[Bridget Peral]

Thereare a bunch of old posts on this topic, but none of them fully clarify this for me. Advice in a few older posts was to choose "Make Other Payment" and enter the amounts owing, applied to their respective accounts. So that is what I am doing, but it doesn't update the amounts owing under "Pay Remittance".

What is the point of the "Pay Remittance" option? I was using it to record the payments before, but then I would have a negative amount in my Accounts Payable. That's why I started recording the payments using "Make Other Payment". Then do I just do a payment adjustment to update the amount owing?

I do not use the Make Other Payment option nor the Pay Remittance option. My method is to print off the balance sheet using last day of period covered, payroll report for period covered and G/L reports for same period. Then I post thru Acct Pay purchase module to vendor of Canada Revenue Agency (CRA) using the invoice date as the period ending date. Then I go thru the A/P payment module and pull up CRA and pay the invoice using the date that I am making the payment on. I then attach the cheque stub or online payment confirmation to the documents that I have printed off and file it. If there are any issues later then I have the printed document to back up what happened at that time.

Yes that is correct. When you create the invoice (I always use a Recurring Entry), list all the liability accounts in the order you see them on the Balance Sheet as of the end of the period. Then when you use the recurring entry, enter the dollar amounts on the balance sheet exactly as you see them on the balance sheet. If it is a positive number, enter a positive number, if negative on the balance sheet for whatever reason, enter a negative (you see this more if you use the same concept in the same way for the GST/HST returns).

Background for the accounting geeks: Basically a positive number entered in the Purchase module will debit any account listed. A negative entered in the Purchase module will credit the account. So if you date the entry on the last day of the period, the balances will go to zero on that day, so the next period starts with a zero balance when you look at the G/L reports. (for the sales module the treatment of the accounting is the reverse - postive number credits the account listed, etc.)

Is it wrong to use Make Other Payment? Not if it gets you the same journal entry. Is it easier? Now that you can adjust entries in the module, it is easier than it was but I still like posting as a purchase invoice as smithco said (I do not think it is worthwhile to learn another data entry window that does the same thing as the Purchase module but looks completely different - a waste of time and energy). And here is the main reason, it is always cash basis accounting so all invoice entries and payments are posted as of the date of the payment.

Is the Remittance feature useful? It gets you the same journal entry. Now that you can adjust entries, it really does adjust and correct the T4 information (it didn't do this for years and many people submitted incorrect T4 Summaries). It posts the entry as of the last day of the period and the payment as of the date on the entry. All that is now good but there is no real place to put line-by-line notes if you wish to (and sometimes you wish to). And you still have to look at your balance sheet until that payment is made to manage your payables.

If you post the entry as a purchase invoice on the first or second day after the end of the period, it sits on your Vendor Aged report so you can manage the amount with the rest of your payables without looking at multiple reports.

If any suggestions provided in this thread are able to help you resolving your issue, would you please click the 'Yes' button to the question - 'Did this answer the question?' The thread will be marked as answered, which will benefit other users who have the same issue. Thanks a lot.

If your CRA remittance was for August, and it's due on Sept 15, recording a Remittance will move all the amounts to be remitted out of the CPP, EI, and Tax Payable accounts as of Aug 31, into Accounts Payable, and record a second JE as of Sept 15 to record the payment.

You can, of course do it any number of other ways. For financial presentation to a bank, they may want to see all your Government debt separately, and using Remittances will lump it in with the other payables in one G/L account.

I thought the Remittance function does not post the payable until the payment date. So technically it is on the balance sheet in separate G/L accounts until the payment is made but the accounts payable entry is back dated at that time.

This also makes the remittance report show the correct numbers for the amount due at all times. If I enter a remittance and am hit by a bus at lunchtime, someone else checking the report for that remitting period can see that there's no amount due, and see the payment.

Ok so I want to make sure I am doing this correctly. The finance girl was laid off last year and I was put in her place with no accounting background what so ever. I figured out how to do the payroll remittance by opening the past ones she did. So here is what I do:

I am using the "Pay Remittance" option yet somehow my balances are all off and never calculate correctly - we recently downgraded from Quantum to Premium and balancing the payroll was a struggle as tax our tax year end and our fiscal year are different - how do I adjust this>

The Pay Remittance option works well if it is setup properly. It will gather all your payroll remittance information and allow you to pay the amounts showing or different amounts. As a suggestion, I would look at your G/L entries to ascertain what the actual amounts, and differences are and record and pay using your purchases and payments screens.

Well, let me tell you, if you have a version installed previous to 2016, keep it, don't update it! Also, if you do not use SAGE, great, don't they will find a way to make you pay no matter what you need or don't need.

yup, Sage is just looking for new revenue

they changed the payroll module to generate more revenue, you have to pay for payroll

and tried spinning it as 'everyone else is doing this'

even if the spin is true, it doesn't make it right

and now as of Aug 1st, renewals will increase by 8%, I just got the email

spun as 'look you now have sage50c cloud access and access to office365'

1) the yearly maintenance fee paid by everyone should fund the development of new features

with just 2 employees, you can use the CRA payroll calculator to calculate the deductions, and use a Sage memorized purchase invoice (employees are vendors) to record the results - allowing you to use the balance sheet to remit source deductions

If you are referring to a US payroll, the liability for payroll withholdings and employer payroll taxes is created when the payroll check is issued, and therefore the Check Date is the most accurate date to use as the Accounting Date. The General Ledger tax liability accounts will correctly reflect the date the liability accrues when the check date is used as the accounting date.

Job Cost transactions created from Payroll processing record both a Transaction Date and an Accounting Date. For payroll time entries sent to Job Cost, the Period End date will be recorded as the Transaction Date and the Check Date will be recorded as the Accounting Date.

I am currently using Sage 100, but am considering upgrading to Sage 300. One of my frustrations with Sage 100 is job costing the payroll. If I have employees working the last week of a month, the payroll ends up posting to the following month. But if we bill the project on the final day of the month, and run a job profitability report for the month, I might have all the income in month N, but all the labor costs month N+1.

Sage 300 CRE does allow you to accrue your payroll time entries to Job Cost and General Ledger. Only Pays are accrued. You do have choices on dates, you can choose Period End Date or Accounting date to accrue your time entries. If you choose Accounting date, you can specify which entries will accrue by using a conditon on date. Your Burden items will flow to JC and GL when you post the checks.

hi - this is the first month I have gone from 1 to 2 employees and I have a problem "matching" the salary payments to the bank account entry created by Sage Payroll.

When I did the payroll run, SAGE Payroll automatically puts in my bank account an entry titled "29/10/2018 Month 7". Previously, when there was just one employee, this amount matched the bank payment of one salary. The problem I now have is that the total salary payment is lets say 4,000 but each individual bank payment is 2,000.

I import bank payments using the online link feature in SAGE Accounting BUT it won't let me match the two bank transactions imported by SAGE from my bank account to the single entry that SAGE Payroll created.

To expand on the "problem". SAGE Payroll links to SAGE Accounting and helpfully automatically adds into "Banking" the transaction for the monthly salary run (from this month now 2 employees). Obviously, when I pay the two employees I make 2 separate payments. So when I import these payments into SAGE accounting it has two bank entries which add up to the total amount of the pay run. The problem is, the "matching" function only lets you match multiple items in the SAGE bank account which together add up to a single imported bank item. You can not match 2 imported bank entries to a single item showing in your SAGE bank account.

When I only had one employee this was not a problem since my imported bank payment was the same as the total payroll payment. Surely there must be a simple solution that I am missing since generally the total payroll payment is going to be split across multiple employees ?

If you subscribe to both Sage Business Cloud Accounting and Sage Business Cloud Payroll, to save you time when you pay your employees, their salary information automatically posts to Accounting. You can choose to post their net wages to your Net Wages Liability Account or automatically post a bank payment for net wages as soon as you complete the pay run. When you record the amount due to HMRC, this also posts the bank payment to clear your liability to them.

3a8082e126