Office Equipment & Supplies Logo

Related Topics:

Question about Canon ImageRUNNER 3570 Copier/Printer

1 Answer

Using Job Accounting with Excel

We have several Canon copiers on campus that we would like to print to. We have job accounting on all copiers. This works well when printing from all software applications except Excel. When we try to print multiple copies from Excel it asks for the copy code for every copy. For example, if I want to print 50 copies of something in Word, I put my code in one time and it prints 50 copies. If I want to print 50 copies in Excel, I have to put in my code 50 times. Not very convenient. Is there any way to fix this? I have search help in excel and nothing addresses this. Thanks. Dena

Posted by Dena Canaguier on


1 Answer


  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Try unticking the collate box on the print window. this can cause 50 jobs to be sent rather than 50 copies of the same job.

Hope this helps

Posted on Nov 19, 2007


Add Your Answer


Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:


I have Kyocer KM-1650. i have employed someone and am not trusting the guy.i need steps to set up the job accounting passward.

Press System Menu / Counter.
Press down arrow and select Job Accounting by pressing Enter.
Enter Admin Pin Code - 1600
Press down arrow to Edit Job Accounting.
Press Enter.
Press down arrow to New Registration.
Enter pin code.

To Switch Job Accounting on:
Press System Menu / Counter.
Press down arrow and select Job Accounting by pressing Enter.
Enter Admin Pin Code - 1600
Press down arrow to Accounting On/Off and press Enter.
Press down arrow to on and press Enter.
Press Reset. (Yellow Button)
ID Code Screen will appear.


This Problem is related with Accounting. You might be trying to print a job to a 7345 which has accounting enabled and you dont have your driver configured to sent the accounting information.
After getting and Accounting ID please go to Printer

Radio Shack Oki C6100 does not print color... only greyscale. Solution on your site might work on another operating system, but the suggested fix is to download a utility called "English Job Accounting...

I'm not familiar with this printer, but my Samsung colour laser has an option in the driver for choosing 'color' or 'grayscale' - make sure it's not something as basic as that for starters.

Need to print a report of past print jobs

If you have CentreWare IS you can do the following (taken from the manual):
You can find the manual link here:

On page 97 of the manual it states:

Using Printer Management Features

Job Accounting

The printer stores information about print jobs in a log file. The log file is stored either in the
printer’s memory or on an optional hard disk if one is installed in the printer. If the log file is
stored in the printer’s memory, it is lost when the printer is reset. It is recommended that a hard
disk be used for job accounting.

The log file lists job records. Each record contains fields such as user name, job name, pages
printed, job times, and toner and ink used. Not all fields are supported by all printers. For
information go to CentreWare IS online help or CentreWare Web online help.

The job accounting values reported vary depending on the protocol and print command used
when each job was printed. For example, using NPRINT over NetWare provides the printer
with the most information about the job being printed. When using Windows and NetWare, the
job name is often LST: or LST:BANNER. Other jobs from other ports may provide less
information about the job.

Job accounting is available through CentreWare IS and CentreWare Web.
Using CentreWare IS

1. Launch your web browser.
2. Enter your printer's IP address in the browser’s Address field (
3. On the right side of the main CentreWare IS page, click Jobs.

The “Job Accounting Links” page provides links that enable you to browse, download, and
clear job accounting records.

For complete information on CentreWare IS job accounting, including clearing job
information, downloading job information to a file, and job accounting file formats, go to
CentreWare IS Online Help.

Hope this helps!


Already we connected the ir3300 machine through we want a weakly printing log for every can i do this?

You can try turning on DepID management. This will not separate photocopying and printing but it will allow you to record how much has been printed for each job/client. Make sure you have Job Accounting turned on in the print preferences/properties (can't remember which) if using this method. Then remember to print the total off each week and clear the totals on the machine.

Alternatively if you want detailed logs (e.g. info on each item printed, can't do this for photocopying I'm afraid) then print charging software such as PaperCut could be useful for you. I currently use the free version of that software (free for 5 users or less). This will provide detailed logs down to every job, what kind of paper was used, b&w/colour and will allow different costs/prices to be set for different size paper, b&w and colour etc. You install PaperCut on the server and share the printer from your server and install the client on each machine.

When i print online, copier counter does not give me print count as per 'Department Code'. I want to setup on-line printing with individual 'department codes'. THIS MACHINE IS CONNECTED WITH WINDOWS VISTA...

if you have the codes in the copiers allready you need to turn job accounting on in the print driver settings find copier under your pronters and faxes right click on it select properties then i believe under the device settings you have to check job accounting then enter the id code

Problem getting a Vista OS computer to see the copier on a network

Make sure there are no firewalls turned on any desktop.  Firewall control should be turned on the router only.
Windows Explorer has some bugs in their browsers that may not work on certain copiers.  It is best to use Firefox or Safari instead to do any administration work on your copier. 

Printing seperate account totals from copier

Press System/menu counter
Scroll down to User/Job accounting
Press Enter
Scroll down to job account set
Press Enter
Scroll down to Account Report
Press Enter
Select Yes
The Job accounting report is printed.

MAC problem with km-3050

What MAC OS are you using? I don't remember for OS 9 and earlier but if you are using OS X I can help you out. First make sure you are using the latest version of the print driver. When you open a document to print and select the Kyocera printer you will see the print dialog box. You need to look under the printer specific options to find the job accounting. I believe it is under set 2.

Hope this helps.

Not finding what you are looking for?


Ask a Question

Usually answered in minutes!

Top Canon Office Equipment & Supplies Experts

old marine
old marine

Level 3 Expert

2411 Answers

Cindy Wells

Level 3 Expert

6497 Answers


Level 3 Expert

85240 Answers

Are you a Canon Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides