Payroll questions

[Gregory Forster]

How I do it, I have 4 spreadsheets in 1 spreadsheet file: Employee 
Records, Payroll Register, Pay Checks, Employee Register.  Many of the 
spreadsheets are linked together at various cell addresses.  I do the 
actual payroll on the spreadsheets. The sheet "Payroll Register" mostly 
creates the payroll for that period. I use the sheet, "Employee 
Register" to record the year to date amounts for each employee. "Pay 
Checks" are the actual pay checks,

You could also create a 5th spreadsheet called Cash Advancements.  You 
can program predetermined formulas, keep records of your Cash 
Advancements. Then you could also keep a record of each employees' cash 
advances in "Employee Register"

This is a very simple system for payrolls with not more than 5, or so 
employees.  A relational database would have to be used for more.  I'm 
not really all that familiar with databases. I've created simple ones 
(LibreOffice) to keep track of hundreds of records.  Using database 
data, you may be able to link database data into a GNUcash transaction, 
However I have no idea how, or even if you can.

I really do not know if you can link cell contents of a spreadsheet to 
transactions in GNUcash.  I don't think you can.

Greg

On 4/17/2012 10:41 AM, Fabiola Verduga wrote:
> Hi Gregory:
> Thanks so much for your feedback.
> On the calculations i'm clear i have to do them separately.
> So, actually there is no way to link the payments to the employees report?
> Also, no link on the cash advance with the employees report?
> I would like to have a schedule transaction for the monthly amount and 
> then at the end of the month deduct the advance payments to know 
> exactly how much is pending to be paid to each one of them. This would 
> really be helpful.
>
> Fabiola
>
>
> > Date: Tue, 17 Apr 2012 09:39:16 -0500
> > From: fgreg74 at gmail.com
> > To: fabiolaverduga at hotmail.com
> > CC: gnucash-user at gnucash.org
> > Subject: Re: Payroll questions
> >
> > Well, first of all, GNUcash does not do the formulations for payroll.
> > To do that, I use a spreadsheet (LibreOffice). However, you can set up
> > whatever you want for asset, liability, equity, income and expense
> > accounts with GNUcash. (I do the payroll for our church. The taxes and
> > year to date calculations are done on the spreadsheet.) What I would do
> > for advance payments is set the pay advance as an asset (like
> > Receivables) though I'd probably label it Cash Advance. Then when you
> > advance, you credit Cash (or Checking) and debit Cash Advance. When you
> > actually pay, you split the transaction: debiting Salary expense for 
> the
> > full amount, credit Cash (for the balance minus the Advancements and
> > whatever tax liabilities), credit Cash Advance and whatever tax account
> > liabilities. BTW, make sure it balances.
> >
> > Greg
> >
> >
> >
> > On 4/14/2012 3:14 PM, Fabiola Verduga wrote:
> > > Hi:
> > > I have a small business with 2 regular employees.
> > > I pay them twice a month but on weekly basis they will ask for some
> > > cash advance.
> > > I need your assistance in order to know how to register the fortnight
> > > payments and deduct the advance money i have given to them.
> > > Example>
> > >
> > > Carlos total Salary is $800 - Expense: Salaries
> > > The tax for the employer is 11% which is $88 - Tax
> > > The tax for the employee is 9% whic is $72 - Tax
> > >
> > > On April 8 i give Carlos $10
> > > On April 10 i give Carlos $5
> > > On April 15 I pay to Carlos $400 corresponding to 50% of his salary
> > >
> > > 1) In which account do i register the advance payments done to Carlos?
> > > 2) How do i know what is the remaining amount to pay to Carlos? -
> > > which report?
> > > 3) How do i register the final payment?
> > >
> > > Thanks for your support.
> > >
> > > Regards,
> > > Fabiola
> > > 3)
> > >