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 on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: Using Job Accounting with Excel

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

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer


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

Oct 05, 2010 | Xerox Printers & Copiers

1 Answer

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.

Mar 26, 2010 | OKI C6100n Laser Printer

2 Answers

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!


Jul 17, 2009 | Xerox Phaser 6250DP Laser Printer

1 Answer

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.

Jul 15, 2009 | Canon imageRUNNER 3300 All-In-One Laser...

1 Answer

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

Dec 11, 2008 | Printers & Copiers

1 Answer

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. 

Oct 24, 2008 | Canon imageRUNNER C3220 Color Copier

1 Answer

Code login for multiple users

Canon has released the Uniflow suite but it is a bit expensive for a small office with less than 5 computers
I would suggest you to create ID's for every user. Then form web interface create limitations for every one.
For network printing just activate the job accounting form the drivers properties

Oct 06, 2008 | Canon imageRUNNER C3220 Printer

1 Answer

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.

May 23, 2008 | Kyocera CS-2050 Black and White Copier

1 Answer

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.


Mar 25, 2008 | Kyocera Mita KM-3035 All-In-One Laser...

2 Answers

Printing problem

Press Copier management button and You can see what is wrong in management settings.probably You reached some limitations adjusted in management mode.Default pasword for copier management is 2500.
If you dont know what to do, switch off copier management.

Nov 13, 2007 | Kyocera Mita KM-2530 Laser Printer

Not finding what you are looking for?
Printers & Copiers Logo

Related Topics:

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Canon Printers & Copiers Experts


Level 3 Expert

94267 Answers

old marine
old marine

Level 3 Expert

1325 Answers

Donald DCruz
Donald DCruz

Level 3 Expert

17129 Answers

Are you a Canon Printer and Copier Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides