Hello all,
I'm new to BC/NAV so I apologize in advance if I'm asking something relatively elementary. However, I have searched online for 2 days and not been able to figure out the best way to do what my company is asking. Our commission calculations are complex so they are calculated outside of BC (in Excel). However, every commission payment can be traced back to a specific job that does exist within BC. All we want to do each week is take a list of total gross commission payments per job and upload them into BC somehow. It would be a very basic list that looked like this.
Job A - $2200.83
Job B - $1554.27
Job C - $835.67
We would want to record these commission/labor expenses to the jobs and hit the G/L expense accounts based on the job types so we could have a better idea of individual job cost (we are currently only tracking supplies associated with each job). To be clear, these costs would never be invoiced, these are just for our own internal job costing purposes. Should this be done with a journal entry? If so, would we use Job Journals or Job G/L Journal (having trouble finding information online that tells me difference between these 2 modules).
Thank you for any information you can provide!
